Measure datatypes mapping using Dax studio

Question

Hi,I am trying to export the measures and their datatypes from&nbsp; 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 which one is which(String, numbers, etc)?

lbendlin · Answer

2 = Text
6 = SmallINT
19 = BigINT

mfelix · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
Check if any of this links helps you:
&nbsp;
https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Querying-DMV-Data-Types-in-DAX-Studio/td-p/3373937
https://www.maxwikstrom.se/power-bi-administration/export-your-power-bi-dax-measures-using-dax-studio/
&nbsp;

anonymous · Answer

Hi, I can see the datatypes but they are in numbers. I need to map them to words, like Text, Decimal number and ... How Can I get that?

lbendlin · Answer

Not sure why you would need that but here's the reference - you can do your own mapping
&nbsp;
Data types supported in Analysis Services tabular models | Microsoft Learn

anonymous · Answer

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?

Forum Discussion

Measure datatypes mapping using Dax studio

9 Replies

Related content

Datatype

Lakehouse table datatypes

Azure Map with two measures

Text to date datatype

Filled map