Forum Discussion
List files in folder without metadata
Luggruff ,Based on what I got
When you look at step. At first or second step it will show the file names. You can delete all steps post that and create custom steps as per need
refer if needed
Hi, sorry for the late reply. This does not work, and is what I have tried. Power BI will still loop through every single file. The source step shows a content column with binary tables, which is the actual content of the files, meaning it has already loaded the data.
For now, I solved it by creating a Power Automate Desktop flow listing the files in the folder, then exporting that to a .csv file which I then run through Power BI instead, as it will only contain text lines of the file names. It is less optimal though, as I manually have to run it before refreshing Power BI.