Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Measure datatypes mapping using Dax studio

Hi, I am trying to export the measures and their datatypes from  my Power BI and I used the DAX Studio. The data types are coming in numbers like 5, 20, 12,... Is there a mapping table to find out w...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Ibendlin,

The reference you sent me does not have any mention of the codes which I see in the DAX studio. Am I missing something?

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Connect to your dataset in DAX Studio. Run 

     

    select * from $SYSTEM.TMSCHEMA_COLUMNS

     

    and then infer your mapping.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Here is the issue:

      How can I find out what is 2, 6, or 9? It is not present in the link you provided. 

      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

        2 = Text

        6 = SmallINT

        19 = BigINT