Forum Discussion
Help: import google sheet by Power query to Excel
I have been having the same issue since last Friday with Excel files that I've been using for over two years. The issue also arose in Power BI for queries using the same anonymous authentication method. I tried refreshing on my desktop and my laptop - restarted the computers, cleared caches, checked for updates, etc. Nothing worked.
From what I can tell, this function is simply no longer available. When I switched the authentication method in Power BI to "organizational account" and used my Google credentials to authenticate, it worked, even though the Google Sheet was still set to public for anyone with the link.
I read that Google has been rolling out mandatory multi-factor authentication across its platform, and it's my suspicion that this is affecting the anonymous access function, even for files public for anyone with the link. I don't know if this is true, but I have tasks to finish, so I'm switching all of my work over to Power BI right now.
Hi 神游中的Eddy,
Before using the URL in excel to Get Data make sure you have made the required changes in General Access and given the access to anyone with the link.
You can get this access setting on the right top corner of the google sheet. Click on Share option and change the access settings accordingly.
After the setting is changed to "Anyone with the link" you can use the URL in Get Data -> From other sources -> From Web, without any credential requirement error.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Hammad.
Community Support Team
If this post helps then please mark it as a solution, so that other members find it more quickly.
Thank you.
Thanks v-mdharahman, yeah, I tried the method you mentioned. but I still can't get the google sheet data. I decide to use Power BI connector instead as Kaesebro mentioned.