Forum Discussion
Solved
Power Query get columns
Any idea how I can get the name & date modified columns with power query?
From UI, you may follow these steps,
1. To keep only needed columns, select the columns: 'Content', 'Name', 'Date modified', right-click and choose Remove Other Columns
2. Import file content
- Click the Add Column tab
- Choose Custom Column
- Name it: Data
- Use this formula:
Csv.Document([Content], [Delimiter=";"])3. Promote headers by clicking Use First Row as Headers on the top ribbon
4. Expand nested table
In the main query, click the expand icon beside the Data column
Select the columns you want to import (from your CSV conten)
Do you really want these? The data in those columns would then be replicated in all rows of the expanded CSV files. Depending on the number of rows in each file that can add up (although in fairness these columns will compress very well in Vertipaq)