Wrong data after query connection

[Georgi97]

Hi guys,

When I connect the raw data with the template that I use, everything looks good. The numbers are correct compared to the raw data:

When I save and load the query, than the numbers look different in all tables, do you have any idea why? There are any matches between the numbers from the raw data. In the cells I do not have any formulas that can changed the numbers.

[lbendlin]

There are lots of steps in your Power Query where this can go sideways. Go through them one by one and make sure it produces the expected result.