Google sheet URL changes when refreshing data

[April]

Hi,

I'm using an AWS virtual machine in which by refreshing the data, the following error occurs:

Web.Contents failed to get contents from (https://doc-08-60-sheets.googleusercontent.com/export/<guid1>/<guid2>/<guid3>/<guid4>/*/<sheet guid>?usp=xlsx') (400): Bad Request

The above URL which is mentioned in this error message is different than the original source URL, please see below: 

ORIGINAL IN SOURCE URL
https://docs.google.com/spreadsheets/d/<sheet guid>/export?usp=xlsx

I can view and download the original source URL.

Can anyone please help? Thanks.

[v-lionel-msft]

Hi @April ,

It may be that your connection steps are wrong (such as using the wrong URL), try to refer to the following article.

Connect Google Sheets to Power BI: An Easy Guide 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@April , Not very clear. But there is minor modification required in google sheet url to access on power bi

I discussed here, see if that can help -https://community.powerbi.com/t5/Power-Platform-Integrations/Power-Apps-Power-BI-Better-together-Wri...

[April]

Hi,

The thing is that we download the google sheet to excel, please check the original source URL:

https://docs.google.com/spreadsheets/d/<sheet guid>/export?usp=xlsx

Error message contains a very different URL.

https://doc-08-60-sheets.googleusercontent.com/export/<guid1>/<guid2>/<guid3>/<guid4>/*/<sheet guid>?usp=xlsx'

The google sheet has been set to "Anyone who has the link can VIEW"

We also tried export?format=xlsx, same error.

How can we solve this error message?