There’s now an official connector to Google Spreadsheets on Power BI
With the November 2021 Power BI release, came the official connector support for Google Spreadsheets from Microsoft. As such there’s no more need for my custom connector. The repository on GitHub is now archived.
No more Relationship tag contains incorrect attribute. Line 2, position 86
During the last week I’ve tested it so see if it had the same
limitations as mine had and I’m happy to report the XML errors when
trying to import data from a Google Sheet with a pivot table don’t
occur in the new one. No more having to create a proxy file and use
the
IMPORTRANGE
function.
Nice job Power BI team! Keep it coming and listening to the community.
Have Fun!