Regular Visitor

6 years ago

Status:

Accepted

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

Any ideas

Thanks

5 Comments

v-qiuyu-msft
Community Support
6 years ago
Hi anbarb ,

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

Best Regards,
Qiuyun Yu
v-qiuyu-msft
Community Support
6 years ago
Status changed:
New
to
Accepted
v-qiuyu-msft
Community Support
6 years ago
Hi anbarb,

I got information that this is by design. See https://docs.microsoft.com/en-us/power-bi/service-dataflows-create-use, 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
anbarb
Regular Visitor
6 years ago
v-qiuyu-msft thanks !
I'll cast it in a view before the dataflow.

Best regards
v-xuding-msft
Community Support
6 years ago
Hi anbarb ,

The issue had been fixed. Please have a try. Hope it is working perfectly on your side.😉

Completed Ideas