Error in Connecting Google Sheet

[Rahp]

[v-tejrama · Accepted solution]

Hi @Rahp,

Thanks for reaching out to the Microsoft fabric community forum.

The error you're seeing usually happens when we try to connect to a Google Sheet using the "Web" connector with just the sheet’s URL which Power BI doesn't support for this type of operation.

Instead, you should use the dedicated "Google Sheets" connector.

Here's how: In Power BI Desktop, go to Home → Get Data → More → Search for "Google Sheets" and select it. Then click Connect. Sign in with your Google account when prompted and allow access.

After that, you’ll see your available Google Sheets  just select the one you want and click Load.

Make sure you’re using the latest version of Power BI and are signed in properly.

Let me know if this helps or if you run into anything else.

If the response has addressed your query, please  "Accept it as a solution" and give a "Kudos"  so other members can easily find it.

Best Regards,
Tejaswi.
Community Support

[v-tejrama]

Hi @Rahp ,

I hope the information provided has been useful. Please let me know if you need further clarification or would like to continue the discussion.

If your question has been answered, please “Accept as Solution” and Give “Kudos” so others with similar issues can easily find the resolution.

Thank you.

[v-tejrama]

Hi @Rahp ,

I hope the information provided has been useful. Please let me know if you need further clarification or would like to continue the discussion.

Thank You.

[v-tejrama]

Hi @ajaybabuinturi,

May I ask if you have resolved this 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.

[ajaybabuinturi]

Hi @Rahp, 
Could you please provide more deatisl regarding how your trying to connect the Google sheet step by step. It's easy to understand to encounter the issue.

[Rahp]

In simple ways as we connect data source in Power bi through link