Forum Discussion

bradleyteoh's avatar
bradleyteoh
New Member
2 years ago
Solved

Couldn't load the data for this visual MdxScript(Model) (8, 40) Failed to resolve name 'SYNTAXERROR'

There is no issue when i view my charts in PowerBI desktop, however error happens in PowerBI service. It was working fine previously.

 

The error message:

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

 

 

  • It was my DAX measure syntax!
    I used VAR FUNCTION which might get confused with actual function names in DAX. Just need to change VAR FUNCTION to some other name.

1 Reply

  • It was my DAX measure syntax!
    I used VAR FUNCTION which might get confused with actual function names in DAX. Just need to change VAR FUNCTION to some other name.