Forum Discussion
Discount column values change to 0 after loading from Power Query to Power BI
I am experiencing an issue with a Discount column in Power BI.
In Power Query, the column contains the correct decimal values such as 0.10, 0.20, 0.05, 0.15, etc. However, once the data is loaded into Power BI (Data view), all the values in the Discount column become 0.00.
Details:
- The data type in Power Query is Decimal Number
- The values appear correctly in Power Query preview
- After applying and loading the data, the column shows 0.00 for every row in Power BI
- Other numeric columns (Sales, Quantity, Profit) load correctly
I have attached two screenshots:
- Power Query view showing correct discount values
- Power BI Data view showing the column as all zeros
Could this be related to:
- Data type conversion during load?
- Column formatting or summarization?
- Model transformations or relationships?
What could cause a numeric column to load correctly in Power Query but change to 0 in the Power BI model, and how can I fix it?
Any guidance would be greatly appreciated.
Hi. Can you share your power query code to make sure there isn't something odd there. Usually when showing 0 it's a decimal thing, data type o coma place. But this time looks kind of good. Make sure data types are correct, click at the column once the data model has refreshed and check it. Try adding decimals shown in a visual to check if there is not a problem that the number is before two decimals like 0.0015. We can check better with power query.
Regards,
hi Beatrice_Wambui,
Without the Power Query example this one is a little hard to diagnose. But, what you can try is to check in the Power BI Report (not Power Query) that there is not any rounding on that field. Just select the Discount column in your data pane and go to the Column Setting ribbon at the top.
I would check through all of this and make sure it is correct. Some changes on the Front end of Power BI Desktop don't always push back to Power Query.
5 Replies
hi Beatrice_Wambui,
Without the Power Query example this one is a little hard to diagnose. But, what you can try is to check in the Power BI Report (not Power Query) that there is not any rounding on that field. Just select the Discount column in your data pane and go to the Column Setting ribbon at the top.
I would check through all of this and make sure it is correct. Some changes on the Front end of Power BI Desktop don't always push back to Power Query.
Hi Beatrice_Wambui ,
Thank you for reaching out to the Microsoft Community Forum.
Hi d_rohlfs , Thank you for your prompt response.
Hi Beatrice_Wambui , could you please try the proposed solution shared by d_rohlfs ? Let us know if you’re still facing the same issue we’ll be happy to assist you further.
Regards,
Dinesh
Hi Beatrice_Wambui ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.
Regards,
Dinesh
Hi. Can you share your power query code to make sure there isn't something odd there. Usually when showing 0 it's a decimal thing, data type o coma place. But this time looks kind of good. Make sure data types are correct, click at the column once the data model has refreshed and check it. Try adding decimals shown in a visual to check if there is not a problem that the number is before two decimals like 0.0015. We can check better with power query.
Regards,
Hi Beatrice_Wambui , Can you please share your Power Query with some sample data to replicate the scenario ?
Thanks
