Showing results for 
Search instead for 
Did you mean: 

Currency in Dataflow

Hi all,

i have a problem with a currency column in my dataflow. 

When i open the dataflow entity editor, when my column is automitically set as currency or i set it as manually,

I save it but in my entity those columns are recognize as Decimal... ex.png

Any ideas 




Status: Accepted

Hi @anbarb ,


I have reported this issue internally: CRI 176581125. Will keep you update here once I get any information. 


Best Regards,
Qiuyun Yu

Status changed to: Accepted

Hi @anbarb


I got information that this is by design. See, section "consideration and limitations" - dataflows do not support M language's (aka Power Query) currency datatype. That's we translate it to decimal. The user should cast it to a supported type (in M).


Best Regards,
Qiuyun Yu

Regular Visitor

@v-qiuyu-msft thanks !

I'll cast it in a view before the dataflow. 


Best regards