Status:
New
Problem with Google data sources connection
Hello! I have a big problem with data sources connection in PBI Desktop, especially WEB page from Google Spreadsheets. Today I come across with this problem with my existing data, I have been workin...
First solution, in the share button activate the option "anyone who has this link" and that's it.
Solution for those who do not have the option to leave the link open as public or do not wish to do so
""https://docs.google.com/spreadsheets/d/{your ID}/export?format=xlsx&id={your ID}""
In the link above, replace by the ID of your document that is, "{your ID}" by your "ID"
change the resulting link to the one you currently have in BI and voila.
Note.- your ID is in the URL of the sheet, it is the one between "https://docs.google.com/spreadsheets/d/ " and "/ view # gid = 64684168867"