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.