Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Selecting source files from sharepoint folder

Hi   I want to import files from a sharepoint site. I am connecting to the site, all well, and I'm presented with a huge list of files.   I know that the files that I want to import are the ones ...
Need Help
Show and Tell
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Anonymous ,

Sorry, I still a little confused about your sceanrio.

If you want to load the specific files in the SharePoint folder when loading, I'm afraid that we cannot achieve that directly currently in Power BI. We need to load all the files in the Sharepoint folder and then filter the files you need.

I'm not understand your step "REMOVE 5000 top rows", could you explain it ?

Best Regards,

Cherry

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

v-piga-msft 

 

I have managed to get into power query all the files in the sharepoint directory.

 

How can I then remove the files I want, but not by selecting one by one, but with a specific criteria.

 

I can get the list as in your screen shot, but then I can't go selecting files one by one. I use a "contains" filter criteria in the file name.

 

If I select with the filters the ones I want and then press "Close and Apply" will powerbi import data ONLY from the files I have selected.

 

if not, how can I delete the files (rows) that are not selected? or, if I select with filters the files I DONT want, how can I delete the selected ones and then remain with the ones that I want.

 

BR