Forum Discussion

Rahp's avatar
Rahp
Helper I
1 year ago
Solved

Error in Connecting Google Sheet

 

Tutorial Requests
  • v-tejrama's avatar
    v-tejrama
    1 year ago

    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

     

     

     

6 Replies

  • ajaybabuinturi's avatar
    ajaybabuinturi
    Super User
    1 year ago

    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's avatar
      Rahp
      Helper I
      1 year ago

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

  • v-tejrama's avatar
    v-tejrama
    Community Support
    1 year ago

    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's avatar
      v-tejrama
      Community Support
      1 year ago

      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's avatar
        v-tejrama
        Community Support
        1 year ago

        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.