Forum Discussion

tex628's avatar
tex628
Icon for Community Champion rankCommunity Champion
7 years ago
Solved

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: ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
sebadb9
Icon for Kudo Collector rankKudo Collector
7 years ago

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:

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

 

 

MatthewRoche is de product development team aware of this issue? 

  • tex628's avatar
    tex628
    Icon for Community Champion rankCommunity Champion
    7 years ago

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

    / Johannes