Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Not applicable

'Relationship Tag' error google sheet to Power BI.




I was trying to connect a google sheet to Power BI so that i could extrat data from the same. But i got the problem  - "Relationship tag contains incorrect attribute. Line 2, position 86." 


This was weird because i have tried to connect a google sheet to Power BI earlier but did not face this problem before.

Could anyone help me with this?

Thanks a lot in advance



I had the same mistake, it was because in the excel sheet I used I had to download it from google drive and lost the table format. Not noticing this detail threw me the error in PBI, adding the table format disappeared the error. I hope I have helped and confirm if this error is resolved with this tip.


The same thing happened to me when I tried to connect a book with sheets that had pivot tables. I omitted the sheet that had the pivottable and it was fixed

Hiding pivot tables worked for me. Thanks
Super User
Super User

@Anonymous , In this blog, check the part to connect power bi with Google sheet


You will get a link like<ID>/edit?usp=sharing

And modified it, like this to make it work<ID>/export?format=xlsx&id=<ID>


Then add it as the web sources

Super User
Super User

Hi @Anonymous ,


Not sure why this error is coming, but check responses on following thread:




Best Regards,

Pragati Jain

MVP logo

LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors