Forum Discussion
Dataflow decimal formatting
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
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?
5 Replies
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,
LydiaMy source is MSSQL Server. So that might be a factor. But this is the formatting settings:
DataflowsDataflows
PBI DesktopPrevious 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
