cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SCA01
Frequent Visitor

This Model Does Not Have a Named Expression

This problem is becoming more generalized in our desktop reports and is caused by Measure tables. Finding information on the problem is difficult and I have seen many solutions and tried several, changing name of the table, enabling/disabling load, renaming, etc. The problem is that the solutions are not repeatable, I had one report that every time I  refresh I have to change the name of the measure table over and over again. Does anyone have a technical document that describes the root cause of this problem so that we are not trying multiple solutions whenever the problem occurs?

Thanks for your help.

1 ACCEPTED SOLUTION

Do you have the Enhanced Dataset Metadata preview feature enabled (https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-enhanced-dataset-metadata)?  If so, we're aware of an issue that causes the missing named expression error on refresh/apply changes if you have a table that contains measures/calc columns but no data columns. The workaround for now, as you've already observed, is to add a column to the "measure-only" tables.

 

Once the fix is released, you will not need this placeholder column.

 

View solution in original post

4 REPLIES 4
SCA01
Frequent Visitor

I believe I found another possible solution to the problem. When creating a measure table in the desktop, you create the table, create your first measure and then delete the column in the desktop. Collapse and expand the Fields section and that measure table now has a measure table icon in front of it instead of the table icon. I went into the query editor, deleted the "Removed Columns" step and then removed the column in the query editor. Refreshed the preview and applied changes, no error. Will continue to monitor this in other reports.  

Do you have the Enhanced Dataset Metadata preview feature enabled (https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-enhanced-dataset-metadata)?  If so, we're aware of an issue that causes the missing named expression error on refresh/apply changes if you have a table that contains measures/calc columns but no data columns. The workaround for now, as you've already observed, is to add a column to the "measure-only" tables.

 

Once the fix is released, you will not need this placeholder column.

 

View solution in original post

v-xicai
Community Support
Community Support

Hi @SCA01 ,

 

You may refer to the similar cases:

 

Power BI desktop refresh not working ,

 

PBI Desktop won't let me discard query changes ,

 

Error message " "The model doesn't have a named expression named <Query>" after clicking 'Apply' .

 

If you still have this issue for Power BI, you'd better create a support ticket in Power BI Support , Scroll down and click "CREATE SUPPORT TICKET", or go to Issue forum  to get further help.

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

amitchandak
Super User
Super User

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!