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 ,

 

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