Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Google Sheets failing to refresh, downloaded data is HTML

I have a host of lookup tables in Google Sheets that I connect to in Power BI desktop via web. The sheets are published to the web as excel workbooks and tis process has been working fine up until to...
Need Help
Show and Tell
Tips and Tricks
jamesjeff9's avatar
jamesjeff9
Regular Visitor
5 years ago

I'm having the same issue. Multiple PowerBI reports connected to Google Sheets via Publish to Web (Excel Document). I found you can reconnect by Publish to Web -> Embed -> Use the URL within the <iframe> but, for me, that leads to a lot of rework in the Query Editor as the table does not come in the same. If I had just one report, okay, but upwards of 10 each with multiple data sources and that leads to a lot of tedious work.

 

Also, have found in another thread that if you update the sharing permissions to anyone with the link, it works again? However, that causes potential data privacy issues.

 

Let's hope this gets resolved soon.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I'm in the same boat. Too many reports relying on various Google Sheets to make any quick modifications. Clearly it isn't an isolated incident which makes me think it's an issue on Google's end.