cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
YaleSOM Frequent Visitor
Frequent Visitor

Auto refresh Google Sheets data

Is it possible to auto-refresh data from Google Sheets in Power BI? Currently, I'm using using the Google Analytics speadsheet plugin to auto-refresh data from the API Query Explorer which allows me to publish to web as a CSV file. I then use the Power BI web connector to connect to the automatically refreshed data in Google Sheets. The problem is that Power BI doesn't automaticaly refresh the data. 

 

 

Does anyone have experience with this or can offer alternatives on how to auto-refresh Google Sheets data?

 

-Brian

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: Auto refresh Google Sheets data

Hi @YaleSOM,

 

After publish to web as .csv file for the Google sheets, and get data from this sheet use web data source, you can publish the report from desktop to Power BI service. Then enter credential use Basic authentication for the data source, and schedule refresh.

 

q3.PNGq4.PNG

 

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Moderator v-qiuyu-msft
Moderator

Re: Auto refresh Google Sheets data

Hi @YaleSOM,

 

After publish to web as .csv file for the Google sheets, and get data from this sheet use web data source, you can publish the report from desktop to Power BI service. Then enter credential use Basic authentication for the data source, and schedule refresh.

 

q3.PNGq4.PNG

 

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Micklow Frequent Visitor
Frequent Visitor

Re: Auto refresh Google Sheets data

Hi Qiuyun,

 

is that we have to install the gateway so that we could configure GoogleSheets and hence schedule refresh?

 

Regards,

Mick Low