Forum Discussion
Quick Measures Deleted when Table Load Disabled
I've got a dataset, where the tables have a number of quick measures to help report designers.
I recently temporarily disabled the load of one of these tables, and it seems that Power BI has deleted all the quick measures in this underlying table. Is there a way I can recover them, or at least stop it deleting them in future if I temporarily disable a table from loading?
Hi Anonymous ,
I don't think they are recoverable now unless you have a backup copy of your report I'm afraid.
In terms of preventing this going forward, some people use a separate measures table rather than storing measures in fact/dim tables that are more likely to be removed from the model.
To create a measure table, go to Enter Data in Power Query and call this table whatever you want. I usually call it "_measures" so it's at the top of my table list in the model view. You don't need to enter any info in this table, just hit OK to create it.
Apply it the the model view, then add a measure to this table. Once you've added a measure, you can delete the blank column that was created when the table was created. If you collapse the Fields pane and re-expand it, you'll now see that this table has a calculator icon marking it as a measure table where you can keep all of your model measures.
Of course, you still need to make sure you don't disable load of this table in Power Query, but it's less likely that you'll do this without thinking as it's now a unique table type.
Pete
Anonymous
I am afraid there is not way to recover the deleted measures, but to keep it without the loading table, you can try move the quick measures to other tables.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi Anonymous ,
I don't think they are recoverable now unless you have a backup copy of your report I'm afraid.
In terms of preventing this going forward, some people use a separate measures table rather than storing measures in fact/dim tables that are more likely to be removed from the model.
To create a measure table, go to Enter Data in Power Query and call this table whatever you want. I usually call it "_measures" so it's at the top of my table list in the model view. You don't need to enter any info in this table, just hit OK to create it.
Apply it the the model view, then add a measure to this table. Once you've added a measure, you can delete the blank column that was created when the table was created. If you collapse the Fields pane and re-expand it, you'll now see that this table has a calculator icon marking it as a measure table where you can keep all of your model measures.
Of course, you still need to make sure you don't disable load of this table in Power Query, but it's less likely that you'll do this without thinking as it's now a unique table type.
Pete
Anonymous , just enable it an check. I doubt you can restore it.
refer my video for better measure management
Anonymous
I am afraid there is not way to recover the deleted measures, but to keep it without the loading table, you can try move the quick measures to other tables.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
