Mismatch - Power BI Query Editor and Power BI Table

[Syndicate_Admin]

I have a table on which I have made few transformations in Power query editor. While loading the data to power bi, I am seeing the data mismatch. I have refreshed the data both in editor and power bi data tab. Also, clear the cache but still facing the issue.

[rubayatyasmin]

Hi, @Syndicate_Admin 

I would recommend checking the PQ steps one by one to find out which step causing the problem. 

also, check for data type errors. click on the dropdown in every column and try to load more data. If the column has a data format error. you will find it there.  

also

1. Check your source data for issues.
2. Fully refresh the data load in Power BI.

also this thread might be of help. Solved: Column Type Mismatch Between Desktop and Query Edi... - Microsoft Fabric Community