Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Mismatch - Power BI Query Editor and Power BI Table

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...
rubayatyasmin's avatar
rubayatyasmin
Icon for Community Champion rankCommunity Champion
3 years ago

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