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
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
Hi PM_Insights
I hope the information provided was helpful. If you still have questions, please don't hesitate to reach out to the community.