Forum Discussion

saud968's avatar
saud968
Memorable Member
1 year ago

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 the data reader. Column count: 19. Existing columns: [ID,TableID,Name,Description,DataType,Expression,FormatString,IsHidden,State,ModifiedTime,StructureModifiedTime,KPIID,IsSimpleMeasure,ErrorMessage,DisplayFolder,DetailRowsDefinitionID,DataCategory,LineageTag,SourceLineageTag]


I am not sure how do I fix this issue, please assist. 

@lbendlin , Greg_Deckler Ashish_Mathur 

@Ahmedx 



 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

16 Replies

  • BeaBF's avatar
    BeaBF
    Super User
    1 year ago

    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

    • saud968's avatar
      saud968
      Memorable Member
      1 year ago

      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).

      • BeaBF's avatar
        BeaBF
        Super User
        1 year ago

        saud968 Try with:
        EVALUATE
        SELECTCOLUMNS(
        $SYSTEM.TMSCHEMA_MEASURES,
        "ID", [ID],
        "Name", [Name]
        )

        BBF