Forum Discussion
bradleyteoh
2 years agoNew Member
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
- bradleyteohNew Member
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.