Forum Discussion
Issue with Google Sheets Authentication in Power BI
I'm experiencing an authentication issue when trying to connect Power BI to Google Sheets. When I try to refresh my existing Google Sheets data connection or edit credentials, the process gets stuck at the authentication screen.
Specifically, when I click on 'Enter' to authenticate, the dialog shows 'You are being connected, please wait...' ('Você está sendo conectado, aguarde...') but it never completes the authentication process. The connection window remains frozen indefinitely.
This issue started occurring suddenly with reports that were previously working fine. I've tried:
Closing and reopening Power BI
Clearing browser cache and cookies
Using different authentication methods
The error appears to be related to recent changes in Google's authentication requirements, possibly related to mandatory multi-factor authentication implementation.
As a temporary workaround, I've exported the Google Sheets data to Excel and replaced the data source in Power BI, but I need a permanent solution for the direct Google Sheets connection.
Has anyone else encountered this issue recently or found a solution? Any help would be greatly appreciated.
Hello Ulisses_Serejo
Use Web Connector with Published Google Sheet
If your data doesn’t require authentication (publicly shared sheet), you can bypass OAuth entirely:
In Google Sheets:
File > Share > "Anyone with the link" > Viewer
Get the published link:
File > Share > Publish to web
In Power BI:
Use Web Connector
Paste the link and transform it with Power Query.
Thanks,
Pankaj Namekar | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
4 Replies
Hello Ulisses_Serejo
Use Web Connector with Published Google Sheet
If your data doesn’t require authentication (publicly shared sheet), you can bypass OAuth entirely:
In Google Sheets:
File > Share > "Anyone with the link" > Viewer
Get the published link:
File > Share > Publish to web
In Power BI:
Use Web Connector
Paste the link and transform it with Power Query.
Thanks,
Pankaj Namekar | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
Hi Ulisses_Serejo ,
Thank you for reaching out to Microsoft Fabric Community.
Thank you pankajnamekar25 for the prompt response.
May I ask if the provided solution helped in resolving the issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you!!
Hi Ulisses_Serejo ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the responses has addressed your query, please accept it as a solution and give a
'Kudos' so other members can easily find it.
Thank you!!
Hi Ulisses_Serejo ,
I hope the information provided is helpful. Feel free to reach out if you have any further questions or would like to discuss this in more detail. If responses provided answers your question, please accept it as a solution so other community members with similar problems can find a solution faster.
Thank you!!
