Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.