Forum Discussion
Community ChampionDataflow decimal formatting
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. :smileysad:
for more info see my post below:
MatthewRoche is de product development team aware of this issue?
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
Community ChampionMy 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?
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
Kudo Collector
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. :smileysad:
for more info see my post below:
MatthewRoche is de product development team aware of this issue?