Vertipaq Analyzer error on SSAS 2022, Compatibility 1600 regarding FormatStringDefinitionID

[zenzeinet]

Hi,

With TE3.7.0 , Vertipaq Analyzer seems broken for SSAS2022 compat 1600. The error message from TE3 is "Could not find the column specified in the context of line 3, column 5".

Running a trace on SSAS it seems TE3 VA runs the following, which returns an error: As far as I remember, previous versions worked ok.

Query Text: SELECT [FormatStringDefinitionID] AS FORMAT_ID, [Name] AS MEASURE_NAME FROM $SYSTEM.TMSCHEMA_MEASURES WHERE [FormatStringDefinitionID] > 0

Thanks

[otykier]

@albertospelta @marcosqlbi are we missing some kind of CL check in VertiPaq Analyzer?

[albertospelta]

@otykier this is probably a bug that has been fixed in this PR https://github.com/sql-bi/VertiPaq-Analyzer/pull/56, released in version 1.2.14.

[albertospelta]

@otykier from what Darren wrote in the PR comment: "it appears that the Dynamic Formatting column in TMSCHEMA MEASURES is not available UNLESS your model has at least one dynamic format string"

[otykier]

Thanks @albertospelta - I'll make sure to use the latest version of VertiPaq Analyzer in our next TE3 update.

[otykier]

As we've upgraded to VertiPaq Analyzer 1.5.1 in our latest release of Tabular Editor 3, I believe this issue should now be fixed. It would be helpful if you could verify this, @zenzeinet - thanks!