Forum Discussion
Sharepoint Site Configuration / Power BI showing only root level folders
Just a heads up:
I submitted a ticket to the Microsoft POWERBI team, and the kindly fixed the issue.
Now, when trying to connect to a specific Sahre Point subgroup, you'll be asked to submit the group's URL address, avoiding the "by default" pointing to the top-level Sharepoint site.
Kudos to the Power BI DEV Team... Awesome team!
Community ChampionSo, typically, connecting to SharePoint you are going after List data, not Documents, I'm not really sure about what kind of useful information that you can get from Documents. When I tried this, I really did not see a way to expand into particular folders, etc. You can try clicking on the "Table" or "Records" that are presented and see if you can drill down into it.
EDIT: mister_arduino, I did prove out that you can scroll over to the Folders column, click on "Record" I believe (for the right folder row) and then click on "Table" in the "File" row and you can get a list of files. You may have to expand beyond that as well.
You may also have some luck using OData and connecting to the older OData web services end points.
Thanks!
Let me be more precise with this issue.
Our Sharepoint server has the following top-level URL:
https://mycompany.sharepoint.com
This root level is defined by the following Folders: FormServerTemplates, SahreDocuments, SiteAssets, SiteCollectionDocuments, etc.
For the purporse of this Visual Management project, we created a new site with the following URL:
https://mycompany.sharepoint.com/sites/mycompany/SharedServices/DashboardsProject
In here, we're planning to dump the datasets that will be imported/synced with PowerBI.
The problem is that PowerBI only shows the top-level folders of https://mycompany.sharepoint.com; our datasets are located on https://mycompany.sharepoint.com/sites/mycompany/SharedServices/DashboardsProject and we can't find a way to point to that site and get the files.
Thanks!
Marco.