Forum Discussion

davidz106's avatar
davidz106
Icon for Helper III rankHelper III
4 years ago
Solved

Define folder path with wild card

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 t...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    - 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.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

- 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.