Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
Solved! Go to 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
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
Hi Qiuyun,
is that we have to install the gateway so that we could configure GoogleSheets and hence schedule refresh?
Regards,
Mick Low
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!