Define folder path with wild card

[davidz106]

I want to query multiple files from a folder "results" for each "projectname". Each project name contains a vast number of files and folders besides "results".

C:\1\projectname\results\

How to tell PBI that I am only interested in "results "folder for each "projectname"? Projectname is a wildcard here for me. 

I know how to pull all the files from all projectname "folders" and then filter it but that makes everthing really slow. Is it possible to set up something like auto indexing? Which tool would be better suited for this job than PBI?

[v-yangliu-msft]

Hi  @davidz106 ,

Here are the steps you can follow：

1. Connect your folders using Power BI Desktop.

2. Click Transform Data to enter Power Query.

3. Click Add Column – Custom Column – enter the following code.

Text.Contains([Folder Path],"results")

4. Select the newly formed column - select True.

5. Result:

The rest are data with "results".

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[lbendlin · Accepted solution]

- use a "contains"  filter on the file path column, set it to \results".  Note that Power Query is case sensitive.

- accessing content from your local C drive is sub-optimal. It will only work for your Power BI Desktop, it will not work on the service.