// 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
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
FIX 1Fix the Navigation step
- 01Open Transform data (Power Query)
- 02Select the failing query and click the Navigation step under Applied steps
- 03Pick the current sheet or table name, or edit the Item/Name value in the formula bar
Did this fix it?FIX 2Check the source file
- 01Open the source workbook and confirm the sheet and table names match exactly, including spaces
- 02Rename back or update the query
Did this fix it?FIX 3Recreate the source steps
- 01Delete the Navigation step and reconnect to the table
- 02For SQL sources, reselect the table in the navigator
Did this fix it?FIX 4Check gateway and credentials
- 01In the service, confirm the gateway data source path matches the Desktop path
- 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 usThe same problem in other apps
All not loading, error messages & connection guides →
Tableau "Unable to Start Due to an Internal Licensing Error" (Tableau)
Looker Studio GA4 Quota Exceeded Error (Looker Studio)
Metabase Dashboard Slow or Not Loading (Metabase)
Superset Dashboard Slow or Charts Timing Out (Apache Superset)
Other Microsoft Power BI errors
- Power BI Scheduled Refresh Failed
- Power BI Gateway Offline or Could Not Be Reached
- Why Is My Power BI Report So Slow?
- Power BI Desktop Refresh and Power Query So Slow
- Power BI Desktop Not Opening or Stuck on Splash Screen
- Can't Sign In to Power BI Desktop
- Power BI Visual Has Exceeded the Available Resources
- Power BI DataFormat.Error: We Couldn't Convert to Number