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 alrea...
  • 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!

     

     

     

mister_arduino's avatar
mister_arduino
Regular Visitor
10 years ago

Just FYI/Update.


PowerBI Documentation states the following:

 

Can I use an Excel document from a SharePoint Online document library?

If the document is in the root Team site, you will be able to connect to it from Power BI by going to Get Data > Files > SharePoint - Team Sites. If you have a subsite, those will not be available, and files will need to be moved to OneDrive for Business.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago
Yeah, I just realized that after I posted my reply, you are using the "Get Data" from the Service. The Service tends to have more limitations. You probably want to put that Excel file on OneDrive to get around this.
  • mister_arduino's avatar
    mister_arduino
    Regular Visitor
    10 years ago

    Yeah, It seems to be a System limitation. I guess the only way to tackle this problem is with a OneDrive Business License.

    I sumitted a ticket to Microft POWER BI Unit, but I guess there's not hope...

     

    Thanks again!!

    • mister_arduino's avatar
      mister_arduino
      Regular Visitor
      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!

       

       

       

      • RyanWIB's avatar
        RyanWIB
        New Member
        9 years ago

        This isn't a fix as it only works on the Browser version.  Myself and others are wanting to link to data within a subsite from the Power BI Desktop application.