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.
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.