Power QueryExercises

Expression.Error: The name wasn't recognized

By Tahir Nas · Examples run in our simulator · Published · Updated

Expression.Error: The name 'Filtered Rows' wasn't recognized. Make sure it's spelled correctly.

M code refers to a step, query or function name that doesn't exist. Usually a step was renamed or deleted, or a function name is misspelled or wrongly capitalised.

Common causes

How to fix it

  1. Make each step refer to the actual previous step name.
  2. Check capitalisation of functions.
  3. Use the editor's IntelliSense to pick names.

Find the step that fails

Minimal example

Raises the error:

let Source = 1, Next = #"Filtered Rows" + 1 in Next

Fixed:

let Source = 1, Next = Source + 1 in Next

Both snippets are run by the Power Query Exercises simulator on every build: the first must raise Expression.Error, the second must run.

Practise avoiding it

Guides

Related lessons