Enhancement Request : Show Table type and column type in Vertipaq Analyzer

[pawarbi]

Would it be possible to show the table type (Import, Calculated) and column type (Column, Calculated Column) in the Vertipaq Analyzer Tables & Columns summary. This will help identify optimization improvement opportunities easily.

Thanks

[marcosqlbi]

From the point of view of the VertiPaq Analyzer library, the information is already there - the ColumnExpression column in the Columns table that is exposed in the view section of the library has a DAX expression for calculated columns and is blank for native columns (imported or DirectQuery - that depends on the partition type).
If you use the VPAX file imported in the VertiPaq Analyzer excel file, you can apply a filter on that column, even though I agree that a "Native / Calculated" attribute would simplify that.
If you use DAX Studio / Bravo / Tabular Editor, such information must be implemented in the corresponding view.
I will keep this item open to evaluate whether to extend the native view in the VertiPaq Analyzer library to simplify the implementation of such a filter in other tools.

[pawarbi]

Thank you Marco. I have submitted a request to Daniel to include this in TE3.