Forum Discussion
Dax Studio Error
saud968 Hi! The $SYSTEM.TMSCHEMA_MEASURES system view retrieves metadata about measures in your data model. Since the error mentions "Failed to get the column type at index 0," it suggests an issue with either the structure or data type of the first column (ID).
Try to do:
SELECT ID FROM $SYSTEM.TMSCHEMA_MEASURES
what do you obtain?
BBF
I know $SYSTEM.TMSCHEMA_MEASURES gets the measures and that's what I want to do.
I get below error when I use SELECT ID FROM $SYSTEM.TMSCHEMA_MEASURES
Query (1, 11) The syntax for 'FROM' is incorrect. (SELECT ID FROM $SYSTEM.TMSCHEMA_MEASURES).
Got this error
Correlation Id: d9b7762b-f21e-1048-e33e-ca558a36c08e
Error Details: Query (3, 1) The syntax for 'TMSCHEMA_MEASURES' is incorrect. (EVALUATE
SELECTCOLUMNS(
$SYSTEM.TMSCHEMA_MEASURES,
"ID", [ID],
"Name", [Name]
)).
