Forum Discussion
Solved
Diff between Data in PowerQuery and PowerBI Table view
Hello guys; I import data from SQL tables and My last table in PowerQury is like this: But the coloumn "tlp_casedone" changes to codes like this in powerBI table view after save and apply Tra...
Power Query shows your data as it is during the transformation steps, while the Power BI table view shows the final data after all transformations and model relationships are applied. So differences are normal, especially if you have filters, calculated columns, or measures in the model.
Hi (Salam),
Please double check to make sure you are not doing any transformation in your steps on the column you specified, if there is no transformation try convert the clumn to text(I know it already shows as if it is text but explicitly doing it might fix some glitchs), then right click, transform, clean( and then also Trim). Hope fully this will fix the issue.