Forum Discussion
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 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
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-Lag0VOiTsdebug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s
2 Replies
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-Lag0VOiTsdebug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s- thank amitchandak !