cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JordanPearson
Helper I
Helper I

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 investigating, PBI is unable to connect to the Google Sheet to bring the data through. This is completely random as it's worth for a month straight with no problem, and no changed have been made since then. 

 

I'm connecting to the GS following this guide: https://natechamberlain.com/2019/10/08/connect-a-google-sheet-spreadsheet-to-power-bi-as-a-data-sour...

 

The error I'm now receiving is: DataSource.Error: Web.Contents failed to get contents from (Google Sheet URL) (400): Bad Request
Details: DataSourceKind=Web

 

Please can someone help? I don't want to connect to the GS in a different way and rebuild the dashboard from scratch, I just want it to stop erroring when I'm connecting to the google sheet, which previously worked.

 

Big thanks! 

1 ACCEPTED SOLUTION

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:

https://docs.google.com/spreadsheets/d/1n9ai02Wh6ntSHt16kd0-jKD3EHJZINw9O9BfXCA/export?format=xlsx&i...

 

New working link

https://docs.google.com/spreadsheets/d/1n9ai02Wh6ntSHt16kd0-jKD3EHJZINw9O9BfXCA/export?format=xlsx

View solution in original post

10 REPLIES 10
Liz_B
Helper I
Helper I

I'm having the same issue as well started this morning and I even tried to change the source to reconnect but it still doesn't work.

Mine is still not work. 

 

Could someone please help me on this issue?

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:

https://docs.google.com/spreadsheets/d/1n9ai02Wh6ntSHt16kd0-jKD3EHJZINw9O9BfXCA/export?format=xlsx&i...

 

New working link

https://docs.google.com/spreadsheets/d/1n9ai02Wh6ntSHt16kd0-jKD3EHJZINw9O9BfXCA/export?format=xlsx

View solution in original post

Greetings, 

 

This solution was working for me when i first saw it, but later that day i kept receiving this error message in my daily refresh.


Dashboard - Financeiro has failed to refresh.
Failure details: The operation has timed out

Next refresh for Dashboard - Financeiro is scheduled for November 26, 2020 15:30 UTC.


Is there something that i'm missing?

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! 🙂 

SWilson_GS
Helper I
Helper I

Experiencing the same. All Google Sheets data sources have been failing in both the Power BI Service and pbix files for about a week and half.

Anonymous
Not applicable

Having the same problem here. It has been working fine for more than a year. Anyone find a solution to this?

amitchandak
Super User IV
Super User IV

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

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?

 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.