Forum Discussion

Ulisses_Serejo's avatar
Ulisses_Serejo
New Member
1 year ago
Solved

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...
Need Help
  • pankajnamekar25's avatar
    pankajnamekar25
    1 year ago

    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 | LinkedIn

    If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

v-sathmakuri's avatar
v-sathmakuri
Icon for Community Support rankCommunity Support
1 year ago

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!!