Forum Discussion

ramviv's avatar
ramviv
New Member
2 years ago
Solved

Extract multiple files from sub folders in sharepoint

Hi   I am new to power bi. I need help extracting multiple files from sharepoint folder. Here is my folder structure in sharepoint       I want to extract all the xlsx files then do the t...
Tips and Tricks
  • KNP's avatar
    KNP
    2 years ago

    Hi ramviv,

     

    You could change the code to the below to ensure files in sub-folders are included.

    Depending on the site size, performance may not be great.

     

    #'Filtered Rows" = Table.SelectRows(Source, each Text.StartsWith([Folder Path], "https://mywebsite-my.sharepoint.com/mycompany.com/Documents/Yearly-Dataset/")),

     

     

KNP's avatar
KNP
Super User
2 years ago

Hi ramviv,

 

You could change the code to the below to ensure files in sub-folders are included.

Depending on the site size, performance may not be great.

 

#'Filtered Rows" = Table.SelectRows(Source, each Text.StartsWith([Folder Path], "https://mywebsite-my.sharepoint.com/mycompany.com/Documents/Yearly-Dataset/")),