Forum Discussion
Google Sheets Connection Broken
I had the issues but I changed the end of the data links used for the source data (export?format=xlsx) and they are all back working.
Below are only examples
Old link:
New working link
https://docs.google.com/spreadsheets/d/1n9ai02Wh6ntSHt16kd0-jKD3EHJZINw9O9BfXCA/export?format=xlsx
JordanPearson , I have connected to GS using the same way. Just check that sheet name is not changed in google sheets or Some permission has changed.
Hi, thanks for your response!
Unfortunately this isn't the issue no. I can't connect to any Google Sheet at all in the same way as before which is exceptionally strange.
Even if I make a blank PBI dashboard, and try connect like I did previously I receive the same error message?
I am having the same problem. I am running about 20 reports and half of them are showing DataSource.Error: Web.Contents failed to get contents from xxxxxxxxxxxxxxxxxxx (400): Bad Request.
I have checked the data addresses and there is no change?