Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I can pull in stuff from team sites or bizname.sharepoint.com/TEAMS/ or /SITES/ but I can't seem to every connect to or find ways to extract data from subsites created off our main page like /IT/ or /HR/ things like bizname.sharepoint.com/SiteICantSeemToQuery/
I assume I'm doing something foolish and just not understanding what it is?
How do you get data out of those "main" subsites?
Solved! Go to Solution.
@OneWithQuestion,
I upload an Excel file to SharePoint subsite, then I input the URL: https://xxxxx.sharepoint.com/teams/testpowerbi/Subsite1 in SharePoint Folder connector of Power BI Desktop to get data, everything works well.
Does the URL https://Company.sharepoint.com/Site/Subsite work in your scenario?
Regards,
Lydia
@OneWithQuestion,
I upload an Excel file to SharePoint subsite, then I input the URL: https://xxxxx.sharepoint.com/teams/testpowerbi/Subsite1 in SharePoint Folder connector of Power BI Desktop to get data, everything works well.
Does the URL https://Company.sharepoint.com/Site/Subsite work in your scenario?
Regards,
Lydia
Thanks!
I was getting some odd errors at first but just closed desktop and reopened a new file from scratch and that worked, thanks!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.