Checking for calculated columns or measures with errors

[eddd83]

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?

[v-yingjl · Accepted solution]

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.

[eddd83]

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?

[PhilipTreacy]

Hi @eddd83 

If the columns are unused then they shouldn't break any measures or calculated columns?

Regards

Phil