Wrong data results after query connection

Copper Contributor

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 before "closed and load":





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.





1 Reply


As a minimum in Power Query you have texts and in grid numbers. If simply load result from first picture it shall return texts in the grid. Perhaps you have some transformations on the way. Desirably to have bit more details - if not the file when query steps.