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