Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Visual Report not Match with Data Table

Hi All, is there anyone have the same problem like me, the data showing on report is not match with data   this is my count (not distinct) of data table (41,897) and below are my table row c...
amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , on the Data tab, go and click on the table. once table display. Below the table, on the status bar, it will show rows loaded. Make sure that numbers are matching. If that is matching. it just you page or visual level filter.

 

If not, open transform Data and check for any error. There should be some error rows. Or check for step, remove error rows in your data transformation step for this table, remove that and look for the error and try to correct that.

 


refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs

debug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    thank amitchandak !