Power QueryExercises

Importing data quiz

Delimiters, encodings, headers and banner rows when importing CSV files.

Revise first: Import CSV files: delimiters, encodings and headers, Remove report banners before promoting headers, Inspect a JSON document before flattening it, Import from Excel: tables, sheets and the navigation table

Question 1

1.After importing a CSV, all data sits in Column1. What's the most likely cause?

Question 2

2.Accented letters show as é after import. What do you change?

Question 3

3.A file starts with a title line and a blank line before the headers. What order of steps works?

Question 4

4.What does QuoteStyle.Csv do?

Question 5

5.What does this return?

Table.ColumnNames(Table.PromoteHeaders(#table({"Column1", "Column2"}, {{"Region", "Qty"}, {"North", "2"}})))
Question 6

6.The banner length varies between exports. Which Table.Skip usage is robust?

Question 7

7.Right after Csv.Document and PromoteHeaders, what type are the values?

Question 8

8.Which are common CSV delimiters? (Select all that apply.)(select all that apply)

0 of 8 answered. Unanswered questions count as wrong.