ErrorIn a TMDL file1 cause · The Report Doctor detects 1.

Column '[name]' in table '[table]' cannot be found or may not be used in this expression

Power BI

In general form, with the parts that change in brackets:

Column '[name]' in table '[table]' cannot be found or may not be used in this expression.

What it means

A DAX expression in the model names a column that Power BI cannot find in that table. The message names the column and the table. It can show as a warning on the table or column whose DAX holds the name, or when you refresh.

Usually
The DAX names a column or measure that was deleted
Fix
Find the DAX that still names it: the table, measure or column with the warning.

Check your project opens the Report Doctor with this message filled in. The text travels in the URL fragment, which browsers never send to a server.

On this page

How the message appears

Copied exactly from each source. A name in square brackets replaced one from someone else's project.

Column 'Profit YTD' in table 'Sales' cannot be found or may not be used in this expression.
Desktop run: Power BI Desktop 2.159.883.0, Studio fixture F13d. Seen 2026-10-23.[1]Typed from a screenshot
1 more report of this message
Column 'y' in table 'x' cannot be found or may not be used in this expression
Microsoft forum: Column 'y' in table 'x' cannot be found or may not be used in this expression. Read 2026-10-23.[2]

What causes it

  1. The DAX names a column or measure that was deleted

    DAX keeps a name after the object is gone. In the quoted thread, the poster deleted a calculated column, refreshed, and got this message. The reply marked as the solution says a deleted column was still used in another column or in an applied step. In our run we deleted the measure Profit YTD, which a field parameter named with NAMEOF('Sales'[Profit YTD]). Power BI Desktop asked only whether we were sure, and named nothing that used it. The warning then said "Column", though Profit YTD was a measure.

    Source: Column 'y' in table 'x' cannot be found or may not be used in this expression[2], Power BI Desktop 2.159.883.0, Studio fixture F13d[1].

    The Report Doctor finds this. It reports “DAX names something the model does not have”, with the file and line.

The fix

Find the DAX that still names it: the table, measure or column with the warning. Change the name to one that exists, or put back what was deleted. If the column came from Power Query, check its applied steps too, as the marked answer says.

In tables/Sales.tmdl:

Broken
sum('Sales'[Qty])

Line 1: add uanti.

Fixed
sum('Sales'[Quantity])

Sales has no column Qty, so the measure names one that does not exist.

From the SalesSense sample project by Rui Romano (MIT licence).

The Power BI Report Doctor reads a PBIP folder or .zip and lists the file and line to fix. Nothing is uploaded. For the other messages a project can stop on, listed by the file that causes each, see Power BI Desktop can't open a PBIP.

Worth knowing

Sources

  • [1]Desktop run: Power BI Desktop 2.159.883.0, Studio fixture F13d. Our run on Wide World Importers open data: we deleted the measure Profit YTD while a field parameter, another measure and a visual still named it. The messages are typed from our screenshots. Seen 2026-10-23.
  • [2]Microsoft forum: Column 'y' in table 'x' cannot be found or may not be used in this expression. The thread title, the original post, and the reply marked as the solution. Read 2026-10-23.

Did this page help?

Your answer helps us know what to improve and what you find useful.

Your JSON and text are processed entirely in your browser and are never sent anywhere. To understand how the site is used we record each page view (the page, the referrer, an approximate location from your IP address, and whether you are a person, a bot or a script) and keep it for 90 days. Nothing is stored on your device unless you choose it. Accept to also store a device identifier here and record your browser and device characteristics, which is what lets a return visit be told from a new one. Decline and no page view is sent. A vote you click on an error page is still counted, and nothing about you is stored. We respect Do Not Track. See our privacy policy.