Forum Discussion

mister_arduino's avatar
mister_arduino
Regular Visitor
10 years ago
Solved

Sharepoint Site Configuration / Power BI showing only root level folders

Hi - 

 

we're currently trying to connect to a dataset from a specific location/Document Library in our Sharepoint site (i.e., /share Documents/myname/mypowerbiproject). This Library has been already defined on out SP environment, and the dataset uploaded. 

 

The problem happenes when accessing in Power BI the Get Data --> Sharepoint - Team Site module; we are unable to browse the specific defined folder that contains the dataset, since PowerBI is only showing the top-level/root site collection (i.e., /share Documents, Site Assets, SiteCollection Documents, etc). 

 

Is there a way to browse deeply into the SP File System, in order to get data from specific locations? 

 

Thank you!

 

 

  • mister_arduino's avatar
    mister_arduino
    10 years ago

    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!

     

     

     

9 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    10 years ago

    So, 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.