Forum Discussion
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?
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 ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
11 Replies
Hi mariag_mureddu,
You need to check whether you have permission to access the sheet. In addition, when you need to google sheet, you need to change URL as below
change
https://docs.google.com/spreadsheets/d/google-sheet-guid/edit?usp=sharing
to
https://docs.google.com/spreadsheets/d/google-sheet-guid/export?format=xlsx&id=google-sheet-guid
You could refer to How to connect google sheet with power bi? for details.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.