Forum Discussion
Data is different in PowerBI and Power Query
Hello, While working with PowerBI I noticed that the numbers look strange when I looked into the numbers, I noticed that the numbers are being shown in PowerBI -> Tables are actually different wh...
Hi redeyequal - Go to Transform Data → Applied Steps (Right Panel).Look for transformations that might be affecting the column (e.g., removing duplicates, type conversions, or rounding).If necessary, remove or modify those steps and reload the data.
Even though Power Query and Power BI show the column as "Whole Number," Power BI may still be treating the column differently (e.g., rounding, truncation, or implicit type conversion).Go to Power BI Model View and check the column data type in the table properties.If needed, explicitly set it to Whole Number (not Auto).
- Check the default aggregation (Sum, Average, Count, etc.).
- In Power BI Table View, go to the column and ensure it’s not aggregating.
Try these steps and let me know what you find!