Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Google Sheets

Hi, when I connect to power bi to google sheets I get "We didn't find any tables on this web page". Do you know how to fix this error?

dax
6 years ago
Hi mariag_murddu,

I test this in my environment, I find that when I connect to web, it will show like below

When I download the Excel and connect this in powerbi, it will have error in it. I think this is caused by the pivot table in your Excel, when I delete this in Excel, it will work. So I sugges you could delete it in your google sheet , and test again to see whether it work or not.

Best Regards,
Zoe Zhi

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

Anonymous

Not applicable

6 years ago

Your test file works fine for me.

I used get data > web > basic to access it.

Anonymous

Not applicable

6 years ago

Sti doesn't work for me.. did you use the link :

https://docs.google.com/spreadsheets/d/1C3p2qZOpmrZm0Dy9StDReuzc_jU8fPsU-gl58yn5TRI/export?format=xlsx&id=google-sheet-guid

?

dax
Community Support
6 years ago
Hi mariag_murddu,

I test this in my environment, I find that when I connect to web, it will show like below

When I download the Excel and connect this in powerbi, it will have error in it. I think this is caused by the pivot table in your Excel, when I delete this in Excel, it will work. So I sugges you could delete it in your google sheet , and test again to see whether it work or not.

Best Regards,
Zoe Zhi

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