Forum Discussion

Anonymous's avatar
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?
Need Help
  • dax's avatar
    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.

     

dax's avatar
dax
Community Support
6 years ago

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 Zhi

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Zoe,

     
    Many thanks for your help:
     
    Yes, I changed the link and I have access to the document as I am the owner.
     
    But when I connect I get this:

     Thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Tried clicking web view instead of table view?

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        it doesn't let me click web view..