Dataflow decimal formatting

[tex628]

Hello! 

I've got several tables uploaded to PBI dataflows and further using them for a report. 

The columns that are in decimal format are not coming out correctly in PBI Desktop:

PBI DesktopPBI Dataflows

Do we know what causes this to occur and how to possibly fix it?

Br,
Johannes

[v-yuezhe-msft]

@tex628,

I am unable to reproduce this issue on my side. Have you  changed the type of the columns in Dataflow to decimal number?

Source excel filedataflowdataflowPower BI Desktop

Regards,
Lydia

[tex628]

My source is MSSQL Server. So that might be a factor. But this is the formatting settings: 

DataflowsDataflows
PBI Desktop

Previous image is taken with raw data from flows, no transformations

Any idea's?

[v-yuezhe-msft]

@tex628,

What data type do you set for the column in SQL Server? Could you please the original sample data in SQL Server table? It seems that you store whole numbers as decimal number in SQL Server table.

Regards,
Lydia

[sebadb9 · Accepted solution]

I'm experiencing the exact same problem. I use dataflows, power BI desktop and then I publish to power BI service.

I use Locale for import: Dutch (Belgium), in power BI desktop.

this makes dataflows unusable until fixed. 

for more info see my post below:

https://community.powerbi.com/t5/Issues/Dataflows-UK-US-Date-Format/idc-p/586344/highlight/true#M362...

@MatthewRoche is de product development team aware of this issue? 

[tex628]

Thanks for the information @sebadb9, a fix would be wonderfull. 

/ Johannes