powerBI(data view) changing my values

[danielolaniyi1]

I loaded a table containing the price of Gold from 2014 - 2024 into powerBI but the values of the csv file in powerquery is entirely different from the values in powerBI (data view). Any help would be greatly appreciated.power query (correct)powerBI (changed)

[OwenAuger · Accepted solution]

Hi @danielolaniyi1 

This looks to be a reordering of the rows.

Can you verify that the row count and aggregate values of columns are the same in the source (using another tool) and the Power BI table?

When tables are loaded to a Power BI semantic model, the rows are not guaranteed to be in a specific order. 

The engine reorders rows to optimise compression, which is why it is common to see repeated values grouped together in certain columns (e.g. Time and Volume in the screenshot).

Regards

[danielolaniyi1]

You're absolutely correct, i checked the sum on excel and its the same. Its just been ordered different in powerBI vs how it looked in power query. Thanks for you help