'Relationship Tag' error google sheet to Power BI.

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

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

https://community.powerbi.com/t5/Power-Platform-Integrations/Power-Apps-Power-BI-Better-together-Write-Back-From-BI/m-p/1044976#M16

You will get a link like

https://docs.google.com/spreadsheets/d/<ID>/edit?usp=sharing

And modified it, like this to make it work

https://docs.google.com/spreadsheets/d/<ID>/export?format=xlsx&id=<ID>

Then add it as the web sources

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.

Hi Anonymous ,

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

https://community.powerbi.com/t5/Desktop/Relationship-Tag-error-when-trying-to-connect-a-google-sheet-to/m-p/205488

Thanks,

Pragati

Help me solve this problem please, lel excel I have it linked to AppSheet, and loading data and updating the power BI gives me the target error.