Forum Discussion
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...
Interestingly enough, If you press "Share" and grant "Editor" to anyone with the link or to a specific account It'll fix the problem for the published to the web documents. At least it worked for me.