Google sheet data download suddenly stopped working

[michael163]

I use data from google sheets in a number of our apps and as of this morning I got the same error message that they weren't automatically updated in Service. After further inspection (in PBI desktop) I found out that these connection don't download data they are supposed to but some gibberish in html (I attach the picture). I tried the links and when I put them in browser they work correctly as they download what PBI is supposed to but doesn't. I need an urgent help as I am clueless and almost all my business relies on these data downloads, thank you!

[michael163]

Thank you all for the reply. As the first solution I received was to change the download links, I spent whole day on rewriting them for every app that we have. This worked but it worked only beacuse I did the second step ->

I found out that all that I needed to do was what @zzajac81 was saying, which is only to switch in Share button Get Link section to "Change to anyone with the link".

Until now I don't know the difference between publicizing the link to the web and writing the link in a manner suggested by this thread  https://community.powerbi.com/t5/Desktop/Google-Sheets-Connection-Broken/td-p/1184701. When I found out that I don't have to rewrite whole link I only enabled in google sheet sharing with anyone with the link and it worked as well. So I guess both options will work as long as you have it turned on in google sheet. Thank you everyone for your help!

[zzajac81 · Accepted solution]

Change the goole sheet file permissions to: anyone with the link.

Then it will work.

Probably google changed the authorization method.

[FeroSK-1]

thank you

[trptl]

I have the same issue. I even try to create a fresh dataset, but still the same issue.

[michael163]

@amitchandak  any other ideas pls? I noticed that PBI started to treat my google sheet imports as html but they all are csv 

Source = Csv.Document(Web.Contents("https://docs.google.com/spreadsheets/d/e/2PACX-1vQu....

[amitchandak]

@michael163 , Clear Premisison, and cache and try again.

Check any Awareness item on the latest release on -https://powerbi.microsoft.com/en-us/support/

[michael163]

@amitchandak

I checked the Awarness and there is nothing related to the google sheets.

I cleared the cache.

I cleared permissions for google sheets and logged in using anonymous again.

And it still doesnt work.