Forum Discussion
Table View does not show data correctly
Hello,
I have four different data tables merged into one (CC_Oct_2022) with some steps like relacing errors/changing data types, and everything looks fine in Power Query Editor. But under the Table view, the data shows the same value for all rows, which is incorrect. Does anyone know how to fix this? I need the correct data in Table view so I can download it (by copying table) to a txt file.
Data structure: (merged based on access number which is an unique identifier)
Inaccurate Data in Table view: (same value for columes like Outstanding balance, credit score, etc.)
Thank you in advance!
2 Replies
Anonymous , Usually Power query by default shows 1000 sample rows. The best way is to check the rows, which will displayed in the table view - Status Bar. Is it matching with the source? If yes, the data should be fine.
If not, check have used any merge operation in the power query and, is working fine.
Also, refresh data once and check.
amitchandak, I have tried refreshing data but the table view did not change. The logic and source data looks fine in Power Query Editor, and the table view shows something different which is very confusing.
