Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
We are conecting to a folder which has multiple files -- basically 3 different file formats. Is there a way when we connect to the folder -- maybe going into 'Advanced' where it shows it in M code -- and filtering by specific file names? i.e. We have file names "Positions", "Transactions" and "Returns" all in the same folder. Only want to view where file names begin with 'Position' or end with .xls -- like filtering positions* or *.xls.
Thanks!
Dan
Solved! Go to Solution.
@dancarr22,
Add a custom column in Query Editor using the following formula, then filter the custom column to "Yes".
if Text.Contains([Name], "Equity") then "Yes" else "No"
You can review the example below.
Regards,
@dancarr22,
Change the code in your Advance Editor to the following:
let Source = Folder.Files("YouPath\folder"), #"Filtered Rows" = Table.SelectRows(Source, each ([Extension] = ".xls")) in #"Filtered Rows"
Then in Query Editor you are able to view only those files with .xls in Query Editor, there is an example for your reference.
Regards,
Thanks! This is great -- answer 90% of my question.
One follow-up then will close this: how would I filter by file name instead of file extension -- i.e. All files that begin with or contain '%Equity%'.
Thanks for your assistance with this -- greatly appreciated.
@dancarr22,
Add a custom column in Query Editor using the following formula, then filter the custom column to "Yes".
if Text.Contains([Name], "Equity") then "Yes" else "No"
You can review the example below.
Regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.