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...
Hello people!
Thank you all for your suggestions. It really allowed me somehow to revive my report (without changing privacy because my NDA forbids it)
So, some of my resources come back with the next steps:
- Click the gear icon near your source and change source to CSV Document press OK
- If you have the table below change the source back to Excel Workbook or if (It worked not for all my resources)
OR if you originally downloaded the CSV source, then replace it with Excel, and then again with CSV.
- Then If you have the following table change back source to Excel Workbook and do the next steps:
- Open you online google sheet
- Publish Entire Document to Microsoft Excel
- Add new source with such link (with your document code) “”https://docs.google.com/spreadsheets/d/e/2PACX-1vSG32i7unNJg84UyCA-Nxa34SwP9P4a5zgm8cSaUAij40_L3ffwEiaANCc1F-iDVXFyjiJ_UKs-cnk2/pub?format=xlsx&id=2PACX-1vSG32i7unNJg84UyCA-Nxa34SwP9P4a5zgm8cSaUAij40_L3ffwEiaANCc1F-iDVXFyjiJ_UKs-cnk2””
- Then you can see your sheets with names like Table 1, Table 2…choose appropriate
- Unfortunately, you should perform all you applied steps as in your old source.
Given steps worked for me. I hope it helps you with something