Visual Report not Match with Data Table

[Anonymous]

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 count (48,128)

i have no active filter and no relationship

i already refresh a couple times but the number still the same

any suggestion would be very appreciate

[amitchandak · Accepted solution]

@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]

thank @amitchandak !