Forum Discussion

PM_Insights's avatar
PM_Insights
New Member
1 year ago
Solved

Error connecting to Google Sheets

Hi All,    I am trying to connect my Power BI to Google Sheets that is provided by my client. This is supposed to be a live data-sheet that will get refreshed on a daily basis. While trying to conn...
Connecting to data-source
Connection errors
  • v-priyankata's avatar
    v-priyankata
    1 year ago

    Hi PM_Insights 

    Thank you for reaching out to the Microsoft Fabric Forum Community.

     

    If the sheet name has spaces, so Power BI gets confused unless you wrap it in single quotes. Instead of (Connected Sheet 1!A1 : GI500), use ('Connected Sheet 1'!A1 : GI500).

    The range might be too big or not valid, maybe the sheet doesn't actually go all the way to column GI or row 500 yet. Try a smaller range like A1 : Z100, or even just use the sheet name without any range.

     

    The easiest way is to let Power BI detect the sheets for you. After signing in, it’ll list all the available tabs,  just pick the right one instead of typing the range manually. Less chance of errors that way. 

     

    If this information is helpful, please “Accept as solution”  to assist other community members in resolving similar issues more efficiently.
    Thank you
     

v-priyankata's avatar
v-priyankata
Community Support
1 year ago

Hi PM_Insights 

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

v-priyankata's avatar
v-priyankata
Community Support
1 year ago

Hi PM_Insights 

Hope everything’s going smoothly on your end. We haven’t heard back from you, so I wanted to check if the issue got sorted  If yes, marking the relevant solution would be awesome for others who might run into the same thing.