cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
Resolver I

The model doesn't have a named expression named

Hi, I'm getting an error message that only appears to affect measure tables in my model. When I refresh I get a message The model doesn't have a named expression named. I've never experienced this before and it's only just occurred in the last couple of days.

 

What would be the reason for this, does anyone know?

 

Thanks 🙂

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User I
Super User I

Re: The model doesn't have a named expression named

Hi @davehus ,

 

Have you checked

 

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

 

It may help

 

Cheers

 

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

View solution in original post

9 REPLIES 9
Highlighted
Super User I
Super User I

Re: The model doesn't have a named expression named

Hi @davehus ,

 

Have you checked

 

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

 

It may help

 

Cheers

 

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

View solution in original post

Highlighted
Frequent Visitor

Re: The model doesn't have a named expression named

I also have this error message, which only affects multiple measure tables that I have in my model.

The error message has came out of nowhere for a file that updates on a monthly basis and was being updated today.

Something seems to have broken for measure tables, and seems to affect some Power BI file. This issue affects even the backup copies of the file that I created, which suggests this issue is not limited to just one .pbix file and could be more "a system thing". Frustrating. A 30min exercise update activity has turned into a wasted day. 

 

Thanks for the suggestion @CheenuSing, but the fixes proposed in the thread you suggested haven't helped to fix the problem.

If anyone has more suggestions, please share. 

Highlighted
Super User II
Super User II

Re: The model doesn't have a named expression named

Hi @mo_jo_jo @davehus 

try to click step by step all applied steps for each data source, it can help you to localize a problem


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

Highlighted
Resolver I
Resolver I

Re: The model doesn't have a named expression named

Hi @CheenuSing ,

 

I renamed the measure tables and this seemed to clear that error. That being said, I don't know if this will repeat though as per @mo_jo_jo 's comment. There has be some sort of bug as this has never happened before and has effected all previous versions of the file.

 

Hopefully it doesn't become a regular occurence.

 

Dave

Highlighted
Frequent Visitor

Re: The model doesn't have a named expression named

@davehus  Same here. I have had to create new tables and transfer all measures, which for now seems to have resolved the issue. A pain in the a$$ because this was a big model, with close to a 100 measures, grouped into 7 different measure tables. This model just grew and grew to do different things over time. This model in turn feeds 2 other reports which I will have to update later today as all visuals will now be broken. 

 

Not sure why this error happened, but it sucks and I have taken a bit more precaution this time out. 

This time, with the new tables, I have made sure to include at least one empty/standard column within the measure table.

I kept getting an error within Power Query when I tried to disabling the original measure table (containing just measures), stating that the table contained no valid columns and would be prevented from loading into the model. This then resulted in Query changes not being applied (i.e. apply or discard query dialogue appeared and could not be closed out).

 

My thinking now is that it is prudent to have a "valid" column type, even an empty one, within every table. This should ensure at least it will load every time if for some reason we need to check future issues with any table in the model by enabling/disabling load. 

I do not want to be going through this at some random time in the future because something has possibly been changed by Microsoft backstage in the product; just for the sake of a nice looking calculator icon indicating a measure table.

Not worth doing this again on a model this size. 

 

@az38  Thanks for the response and the suggestion.

Highlighted
Resolver IV
Resolver IV

Re: The model doesn't have a named expression named

I had the same problem with my measures table.  I resolved it by doing this:

1.  Go to Transform Data

2.  Select my measures table

3.  Under Add Column, select Index Column > Select from 0 (or 1, doesn't matter)Key Measures Error.JPG

4.  You may get an error that says "The table is empty", but click through that.

5.  Try refreshing your report.

 

This is what worked for me.

 

Highlighted
Frequent Visitor

Re: The model doesn't have a named expression named

@Roseventura Thanks for sharing that fix. I guess it achieves the same result because it somehow introduces elements that are then recognised within the report "side". Your suggested fix seems much quicker than the reset approach I took 🙂

Highlighted
Resolver IV
Resolver IV

Re: The model doesn't have a named expression named

Glad it worked out!

Highlighted
Frequent Visitor

Re: The model doesn't have a named expression named

This worked for me.  

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors