Power QueryExercises

Module 19

Refresh robustness and performance concepts

Writing queries that survive new data, and what query folding and privacy levels mean.

You'll be able to

Lessons

  1. 1.Dynamic steps that survive new columnsReplace hard-coded column lists with rules that apply to future columns.
  2. 2.Query folding (concept)Explain query folding and recognise steps that tend to break it.
  3. 3.Privacy levels and the formula firewall (concept)Explain privacy levels and recognise formula firewall errors.
  4. 4.Refresh in Excel, Power BI Desktop and the service (concept)Anticipate why a query that refreshes on your machine fails elsewhere, and add checks that report it.

Take the refresh robustness and performance concepts quiz (8 questions)

Exercises