Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.