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.

pankajnamekar25's avatar
pankajnamekar25
Super User
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.