Forum Discussion
Error connecting to Google Sheets
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
Thanks for responding Greg_Deckler . This Google Sheet contains nested dataset. Is that the reason this might be happening? Would you know? How do I un-nest this nested dataset, using Power BI?
PM_Insights Any chance you can share an example of the nested data as a Google sheet? Then I could do some troubleshooting.
