// troubleshooting guide · microsoft power bi

Power BI Error: The Key Didn't Match Any Rows in the Table

Status
Workaround available
platforms:
Power BI Desktop, Power BI service
updated:
November 16, 2026
reports:
3
Method
how we research
Share

RUNBOOK · power-bi/key-didnt-match-any-rows4 FIXES

// quick answer

This Power Query error means a step is looking for a sheet, table or database object that no longer exists under that name. Fix the Navigation (Source) step so it points at the current name, or recreate the query.

Most likely fix: Fix the Navigation step

How to fix it

// try these in order, the most common fix is first

  1. FIX 1Fix the Navigation step

    1. 01Open Transform data (Power Query)
    2. 02Select the failing query and click the Navigation step under Applied steps
    3. 03Pick the current sheet or table name, or edit the Item/Name value in the formula bar
    Did this fix it?
  2. FIX 2Check the source file

    1. 01Open the source workbook and confirm the sheet and table names match exactly, including spaces
    2. 02Rename back or update the query
    Did this fix it?
  3. FIX 3Recreate the source steps

    1. 01Delete the Navigation step and reconnect to the table
    2. 02For SQL sources, reselect the table in the navigator
    Did this fix it?
  4. FIX 4Check gateway and credentials

    1. 01In the service, confirm the gateway data source path matches the Desktop path
    2. 02Make sure the account used can see the object
    Did this fix it?

SANDBOX · power-bi RUNS IN YOUR BROWSER

Try it: browse a sample shop and watch visitors, funnels and live data arrive

A hands-on Microsoft Power BI-style sandbox, including the spots where users get stuck. See where problems like this one start. 1-2 minutes, nothing is saved.

Symptoms

Refresh fails with 'Expression.Error: The key didn't match any rows in the table' in Desktop or the service.

Why it happens

  • C-01Excel sheet or table was renamed or deleted
  • C-02Database table, view or schema renamed
  • C-03Source path or file changed
  • C-04Different credentials see different objects

// this guide also covers

  • the key didn't match any rows in the table
  • power bi expression.error key didn't match
  • power query key didn't match any rows

Still not working?

If Microsoft Power BI keeps failing, you're not alone. See every Microsoft Power BI problem users report or the alternatives people switch to.

Done fighting Microsoft Power BI? Our small team builds your own Microsoft Power BI alternative, or any software you need: web, mobile, games, desktop. Price agreed together.

Talk to us

Watch Microsoft Power BI Get an email when its price changes, it has an outage, or we publish a new fix. No spam.

Fixed it? Share this guide

The same problem in other apps

All not loading, error messages & connection guides →

Other Microsoft Power BI errors

All 14 Microsoft Power BI errors and fixes →