The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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?
Solved! Go to Solution.
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.
Proud to be a Super User!
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.
Proud to be a Super User!