Forum Discussion

apayze's avatar
apayze
Regular Visitor
9 years ago
Solved

Can PowerBI pull data from a SharePoint Online Content Type and present data from all sub-sites

Hi,   I want to roll-up data from across all SharePoint Sites, that have the same content type. (This is simliar to SharePoint Content Query Web part, however the web part is limited to only on col...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi apayze,

    You are able to enter the root URL of SharePoint Online subsite using SharePoint connector and import data of different subsites into your current Power BI Desktop file.

    However, if you want to pull data of all subsites at a time, please firstly check if there is a OData URL returning all data of subsites from SharePoint side, then enter the URL in OData Feed entry of Power BI Desktop to connect to the data.

    Here is a similar thread for your reference.

    http://sharepoint.stackexchange.com/questions/98159/retrieving-list-items-from-multiple-sites-via-odata-with-excel

    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi apayze,

You are able to enter the root URL of SharePoint Online subsite using SharePoint connector and import data of different subsites into your current Power BI Desktop file.

However, if you want to pull data of all subsites at a time, please firstly check if there is a OData URL returning all data of subsites from SharePoint side, then enter the URL in OData Feed entry of Power BI Desktop to connect to the data.

Here is a similar thread for your reference.

http://sharepoint.stackexchange.com/questions/98159/retrieving-list-items-from-multiple-sites-via-odata-with-excel

Thanks,
Lydia Zhang