Forum Discussion
Dax Studio Error
Hi I am getting the below error as per the screenshot Actual error Correlation Id: 45e64fd5-8acd-738e-e54d-c8610e9ec64d Error Details: Failed to get the column type at index 0 from th...
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).