Forum Discussion
Checking for calculated columns or measures with errors
I'm using the vertipaq analyzer to find and to delete large unused columns. However, once I deleted said columns, I have to manually expand and collapse all tables to see if the deleted column broke any calculated columns or measures.
Rather than visually check everything, is there a better way to ensure no broken measures or calculated columns in your data model?
Hi eddd83 ,
When the column is deleted in the data model, the measures and the columns that quoted it would automatically have error message in power bi:
In addition, you can use Tabular Editor to check it:
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Yes. However, I still need to manually visually check everything after deletion. This visual check is both a) slow and b) prone to human error. Hence is there a better method for checking the integrity of all calculated columns and measures?
Hi eddd83
If the columns are unused then they shouldn't break any measures or calculated columns?
Regards
Phil
Hi eddd83 ,
When the column is deleted in the data model, the measures and the columns that quoted it would automatically have error message in power bi:
In addition, you can use Tabular Editor to check it:
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
