Forum Discussion
Solved
Google Sheets Connection Broken
Hi, I've had a dashboard running for around a month using connection to Google Sheets. I woke up yesterday to a "failed refresh email" from PBI advising the report had fallen over. Upon inves...
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
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
Amazing, this worked! Reports are now back up and running and scheduled refresh is now back in action.
Thank you so much, and to everyone else for their help also! 🙂