Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Do we know what causes this to occur and how to possibly fix it?
Br,
Johannes
Solved! Go to 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:
@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?
Regards,
Lydia
My source is MSSQL Server. So that might be a factor. But this is the formatting settings:
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
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:
@MatthewRoche is de product development team aware of this issue?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.