Power Query get columns

Brinki

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

1. Click the Add Column tab
2. Choose Custom Column
3. Name it: Data
4. 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

1. In the main query, click the expand icon beside the Data column

2. Select the columns you want to import (from your CSV conten)