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/expo...
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?
