Google Sheets Data not loading properly - "Unable to load file"

[nicolas23498324]

Hello,

I am attempting to load data from a Google Sheet using these instructions: https://www.bizone.co.th/blogs/business-intelligence/part-3-connecting-power-bi-google-sheets. Put the URL into the Web Data Load option and then select page. However, once I enter the navigator (Table View) I am only presented with some data concerning the website and metadata from the spreadsheet summarizing the tab names.

When I switch to Web View, I am presented with multiple errors, "Unable to load file" and a request to upload to a supported browser.

I have cleared the Data Cache and Q&A Cache in Power BI but that did not help. Is there a way to repoint Power BI to use Edge instead of Internet Explorer? Or another way to get the data to load?

Thank you,

Nicolas

[amitchandak · Accepted solution]

@nicolas23498324 , I had quick look at link, I am not able to locate this in first look

In the case of power bi, there is no direct(seeded) Google Sheet connector. So, we created a shared link with the option  “Share with anyone with having this link”.

We got a link like

https://docs.google.com/spreadsheets/d/<ID>/edit?usp=sharing

And modified it, like this to make it work

https://docs.google.com/spreadsheets/d/<ID>/export?format=xlsx&id=<ID>

see if this can help