Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Gurus,
Recently getting this error.
Already tried republishing sheets, removing access and putting it back. Still not working. My account works with other sheets.
Any help will be appreciated.
Thanks,
Paul
Solved! Go to Solution.
Hi Maggie,
Thanks for your response. Further checked on this and it turned out that it only happens on shared google sheets. I created my own sheet and connect it to Power BI and it did work.
Thanks,
Paul
Hi @polaris3028
I test on my site, create a google spreadsheet and publish it to web(meanwhile it generate a link), then I use the link to connect to in Power BI Desktop. Everything works well.
Could you paste your link in the web browser and open the page?
if you can't get proper contents this way, maybe the google sheets are restricted the access, so you can't connect to it using the anonymus credential, you need ask for the correct credential with author.
Best Regards
Maggie
Hi Maggie,
Thanks for your response. Further checked on this and it turned out that it only happens on shared google sheets. I created my own sheet and connect it to Power BI and it did work.
Thanks,
Paul
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |