Data changes when loaded from Power Query

[User_000]

Hi,

I'm getting an issue where the data changes when loaded from Power Query to Power BI. I haven't done any particular transformation step before loading (only a value replacement), so it feels odd that this is happening. Appreciate any advice I can get.

Power Query:

Power BI

Thank you!

[AmiraBedh · Accepted solution]

Hello !

Power Query only shows the sample data after your applied steps and when you load to Power BI, the full dataset is pulled again (not just the preview) so if your source has duplicates or multiple records with the same Opportunity ID, you’ll see them after load.

For example, if your replaced value or filtered rows steps don’t uniquely identify rows, the duplicate IDs will remain when loading.

Sometimes values look identical in PQ but differ slightly (trailing spaces, case differences) and PQ preview can group or sort them differently, but when loaded, you’ll see both rows.