Forum Discussion
Automatics Refresh
Hello !
Thank you for posting on Fabric community.
Your sheets must be accessible without login and the url should be like https://docs.google.com/spreadsheets/d/e/<pub-id>/pub?gid=<tabId>&single=true&output=csv
Don't forgert that PBI service is strict with dynamic URLs so you need to rewrite your query to use Web.Contents with RelativePath and Query and if you have multiple sheets you can parameterize Gid and reuse the same pattern for each table.
In the service and in the dataset settings under data source credentials you need to set authentication to anonymous, privacy level to organizational. You do not need a gateway for Web/Google endpoints.
Hello !
Thank you for posting on Fabric community.
Your sheets must be accessible without login and the url should be like https://docs.google.com/spreadsheets/d/e/<pub-id>/pub?gid=<tabId>&single=true&output=csv
Don't forgert that PBI service is strict with dynamic URLs so you need to rewrite your query to use Web.Contents with RelativePath and Query and if you have multiple sheets you can parameterize Gid and reuse the same pattern for each table.
In the service and in the dataset settings under data source credentials you need to set authentication to anonymous, privacy level to organizational. You do not need a gateway for Web/Google endpoints.
Thank you so much, this solved my issue!