Forum Discussion
Google Docs CSV returns html instead of data
I checked the HTML page a little further, and it is a login page. Though the settings are so that it is publicly published, it appears to redirect to a login page only to check that a login is not required and then continues or something. In a browser, you don't see this but Power BI fails randomly. Remember: the Google link worked flawlessly for months and I didn't change the report at all.
camargos88: Thanks for your reply. Your solution should work, as my solution should work as well. But it doesn't as of this week.
thnemeth: Thanks for your backup. I'll keep you posted.
edhans: That looks promising. I'll check right now.
--
Update: Worked!
The solution is simple: Go to file > share and change it to 'anyone with the link can read' (or something like that, I'm not using Docs in English). That is rediculously **bleep**ty because I used the 'publish on the internet' feature which is a completely different menu option and didn't need a change in 'share' previously. Apparently, Google changed this without notice.
Community ChampionHello. I also have the exact same issue as jasv.
Mine were working perfectly and yesterday seemed to have stopped.
I have spent much time trying to sort this out, but no luck.
I went to the link posted, but there is nothing there that helps.
My link is currently (edited for privacy):
It is one tab of a google sheets document.
I have two others, from the same document and they are both showing the same html.
The html is also very similar to jasv.
Do we know if this is this a Microsoft issue or a Google issue ?