Power QueryExercises

Refresh robustness quiz

Dynamic steps, schema drift, query folding and privacy levels.

Revise first: Dynamic steps that survive new columns, Query folding (concept), Privacy levels and the formula firewall (concept), Refresh in Excel, Power BI Desktop and the service (concept)

Question 1

1.Which step embeds today's column names in the M?

Question 2

2.What are the columns?

Table.ColumnNames(Table.TransformColumnNames(#table({" a", "B "}, {{1, 2}}), each Text.Upper(Text.Trim(_))))
Question 3

3.What does this return?

List.Difference({"Item", "Jan", "Feb"}, {"Item"})
Question 4

4.What is query folding?

Question 5

5.Which step commonly stops folding?

Question 6

6.What do privacy levels protect against?

Question 7

7.A report must have exactly five columns. Should its steps be fully dynamic?

Question 8

8.Does this practice simulator fold queries?

0 of 8 answered. Unanswered questions count as wrong.