Auto refresh Google Sheets data

[YaleSOM]

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

[v-qiuyu-msft · Accepted solution]

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.

Best Regards,
Qiuyun Yu

[Micklow]

Hi Qiuyun,

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

Regards,

Mick Low