Forum Discussion

admiralman's avatar
admiralman
Advocate II
9 years ago
Solved

Sharepoint Folder

I would like to target a folder within a Sharepoint Online library similar to the "connect to folder" functionality that exists on the local client. Can anyone tell me if this is possible? I have see...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi admiralman,

     

    Based on my test, we have to list all available folders, then select those we need from the list. As mentioned in above link:

     

    Now that we’re in, we’ll be able to see all of the files from all of the folders that we have access to in that specific site. This might be a pretty long list, so let’s do some filtering on the “Folder Path” column and select the folder where your data is being stored so you only get the files from it.

     

    If we direct to a specific folder in URL (https://microsoft.sharepoint.com/xxxx/xxxx/Shared%20Documents/Power%20BI), it will fail to connect and prompt below error.

     

     

    Regards,
    Yuliana Gu

OnwardSolutions's avatar
OnwardSolutions
New Member
5 years ago

Thank you after hours of searching, you saved me so much time. In my case it was also helpful to export  this Power BI query data to excel I used the following steps:

 

Step 1) Query all items and subfolders in a SharePoint Folder data using Power BI: Combining Excel Files hosted on a SharePoint folder with Power BI

Step 2) Tansform and Bulk Export (5000+) items to Excel: using Power BI Desktop:  #PowerQuery – Easily Copy all queries from a PBIX to Excel and vice versa – Erik Svensen – Blog about Power BI, Power Apps, Power Query (wordpress.com)