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

Hi,

I was having the same issue. What fixed this for me was using /export?format=xlsx&gid=130923075 where gid you can get it from the URL of your google sheet. In my case, my google sheet had several tabs including some with Pivot tables and graphs which seem to be causing the issue. Thus, to export just the tab needed, click on the tab and get the gid to be used as shown above. For example the complete URL format will look as below:

https://docs.google.com/spreadsheets/d/1X2RwWGI7412fKLPuyPJg5GHeoTWPrxBTRtvuHJ7Q0nDgo/export?format=xlsx&id=13094301