Question
You have a folder that contains 100 CSV files.
You need to make the file metadata available as a single dataset by using Power BI. The solution must NOT store the data of the CSV files.
Which three actions should you perform in sequence?
Explanation
The Folder connector returns one row per file with metadata columns such as Name, Extension, and dates, plus a Content column holding the file data and an Attributes record. Removing the Content column ensures the CSV data itself is not stored, and expanding Attributes exposes further metadata such as file size. Combining the Content column would load the CSV data, removing Attributes would discard metadata, and the Text/CSV connector reads one file's contents rather than folder metadata.
