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

@SCA01 , Check this

https://community.powerbi.com/t5/Issues/Error-message-quot-quot-The-model-doesn-t-have-a-named/idi-p...

Or check and log a ticket at

https://community.powerbi.com/t5/Issues/idb-p/Issues



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

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!