Google sheet new update error

[osamim]

I try to connect a normal google sheet to try the new realease but it doesn't work on power bi desktop even if i have the latest version of PBi Desktop.

Please can you help me with this error ?

Thank you

[v-yiruan-msft · Accepted solution]

Hi @osamim ,

Could you please tell me if you can connect to the same Google sheet URL address in the older version of Power BI Desktop successfully? What's the version of your Power BI Desktop? By the way, how did you connect to Google sheet? Get data --> Google sheet?

In addition, you can refer the following video to connect to Google sheet using Web connector. 

How to connect Google Sheet with Power BI

Update the Google sheet URL

Best Regards

[v-yiruan-msft · Accepted solution]

Hi @osamim ,

Could you please tell me if you can connect to the same Google sheet URL address in the older version of Power BI Desktop successfully? What's the version of your Power BI Desktop? By the way, how did you connect to Google sheet? Get data --> Google sheet?

In addition, you can refer the following video to connect to Google sheet using Web connector. 

How to connect Google Sheet with Power BI

Update the Google sheet URL

Best Regards

[osamim]

Thank you for your answer, but u found that i try to connect an online excel file (opened on the web as a google sheet) with the new powerbi googlesheet connection.

It does'nt work because it's an xslx format not a googlesheet format.

Have a good day ahead

[Varian · Accepted solution]

You need to transform to Google sheet

[amitchandak]

@osamim , Please check issues or log a new one  -https://community.powerbi.com/t5/Issues/idb-p/Issues