Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to check a tabular model project in Visual Studio for errors in measures

I have a Visual Studio tabular model project, and have done a Rebuild All. It returns "Rebuild All: 1 succeeded, 0 failed, 0 skipped". So I checked the project into source control. But when using one of the changed measures in a PowerBI report, an error is raised:

 

MdxScript(Model) (552, 53) Failed to resolve name 'SYNTAXERROR'. It is not a valid table, variable, or function name.


Turns out a typo in the measure formula had an extra closed parenthesis in the formula.

I thought Rebuild All would report any of these type of errors?

How can I check all the measures in a tabular model project for errors before committing the solution?

No Replies