Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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.
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.
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.
@SCA01 , Check this
Or check and log a ticket at
https://community.powerbi.com/t5/Issues/idb-p/Issues
User | Count |
---|---|
139 | |
113 | |
103 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |