Forum Discussion
Google sheet URL changes when refreshing data
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.
3 Replies
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-Write-Back-From-BI/m-p/1044976#M16
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?
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 ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
