Status:
New
Google sheet data download stopped working today
I use google sheets links in a number of my reports and as of this morning I got the same error message that they weren't automatically updated . After further inspection (in PBI desktop) I found ou...
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"