Forum Discussion
Google Sheets Connector doesnt refresh when published
Hi odonnelljuan ,
As you've observed, while you can connect to Google Sheets from Power BI Desktop and refresh data within the desktop environment, the behavior changes once the report is published to Power BI Report Server. This discrepancy arises because, currently, Google Sheets is not listed as a supported data source for Power BI Report Server. Consequently, direct refresh capabilities and scheduled refresh options for Google Sheets data are not available in the server environment.
More details: Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details.
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi odonnelljuan ,
As you've observed, while you can connect to Google Sheets from Power BI Desktop and refresh data within the desktop environment, the behavior changes once the report is published to Power BI Report Server. This discrepancy arises because, currently, Google Sheets is not listed as a supported data source for Power BI Report Server. Consequently, direct refresh capabilities and scheduled refresh options for Google Sheets data are not available in the server environment.
More details: Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details.
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the details, I understand that, thats why my question was what is the point of such a (not) feature. I understand that in PBI Service (cloud) it does work, at least with scheduling.