Hi all,
I have a power query with a value as shown below....
When I import this column / values to my power bi table it is setting all the value below 0 (0.4 etc) as 0 and not totalling them up as required? Even thought he column is set to decimla and 2 decimal places etc?
Usually after you import data, PQ will change the data type automatically.
you can try to delete the change type step to see if the data is correct.
Usually after you import data, PQ will change the data type automatically.
you can try to delete the change type step to see if the data is correct.
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
