powerbi query data and data tab both showing differently

[Anonymous]

I've already applied the data query editor and the data tab still shows different data. I want the one shown in data query editor within powerbi - can anyone help please.

[v-eqin-msft]

Hi  @Anonymous ,

Any updates?

Best Regards,
Eyelyn Qin

[v-eqin-msft]

Hi @Anonymous ,

It seems that I could not reproduce your issue. My PBI version is the latest version——2.104.702.0 64-bit (April 2022)

I noticed that not only was your data malformed, but the data itself was not the same at all. You may try to refresh your data firstly 

Or remove the "Changed Type" step to make the data as Text type to check if values are same.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.