Looker Downloads to Excel Automatically

Looker Q&A Looker
1

So currently the process is - looker will manually update with about 3 dashboards everyday that being said I need to open looker every morning and download the three files. Once downloaded I then need to export and copy and paste into a shared excel file so that it will upload to our Power BI dashboard. Once they are saved on the shared file I then have to refresh the Power BI dashboard and update it. The process is extremely manual does anyone have any idea that I can get looker to download these files every morning at a certain time and save automatically in the excel shared documents?

Also one note for the excel shared document it is not a running document since it really is just used for a way to move the data from looker to Power BI so I deleted the day before then paste the current day into the excel (just in case that makes a difference)

ANY help would be nice I have to wake up extremely early do this tedious task then go back to bed before starting my day again. Thank you

2

Hi Caitlin,
You can load data you have in looker directly from original datasource (Redshift, …) that looker reads from into power BI. you can tell power BI to read data directly as like as your looker. Here are the steps:

1- find out what is your data source that looker reads from if you don’t know it (Redshift, MySQL, …)
2- go to the looker explore that you want it’s data
2- on the bottom part of explore, you have a SQL tab. clicking on that will show you the underlying SQL query used by looker to generate database/datawarehouse to generate explore’s data.
3. You can copy that SQL query and then build a data connection to your database/data warehouse in PowerBI and put thos query in SQL part of connection.
4. Then you can replace excel table with this new table in your Power BI.
Hope it helps and you don’t have to wake up early anymore. If you needed more help, let me know