Forum Discussion

sushantj's avatar
sushantj
Frequent Visitor
9 years ago

'Relationship Tag' error when trying to connect a google sheet to Power BI.

Hello Everyone,    I was trying to connect a google sheet to Power BI so that i could extract data from the same. But i got a weird message from Power Bi saying - "Relationship tag contains incorre...
Need Help
MendelO's avatar
MendelO
Regular Visitor
7 years ago

Did you add a pivot table to your google sheets?

I encountered the same issue, I deleted the pivot table, refreshed the sheet then refreshed the connection in power query, worked like a charm.

Alternitavely, you can create a new google sheet and use Importrange, get the .xlsx download link and connect to that.

  • ckraus's avatar
    ckraus
    Regular Visitor
    6 years ago

    I had the same issue, removing the pivot table from the Google Sheet fixed it for me.

    • airwreck's avatar
      airwreck
      Frequent Visitor
      6 years ago

      That's actually the issue here. Pivot tables don't work for some reason.

      If you need to keep the table there though like I did, export as a CSV instead by using

      export?format=csv&id=