Forum Discussion
Theo1403
6 years agoAdvocate I
Missing rows in table view
Hello, I run into a strange issue. My report is showing incomplete data. I checked my queries and I found out that I miss certain rows in table view, while these rows are visible in query editor aft...
Theo1403
6 years agoAdvocate I
Hello tarunsingla Cmcmahan
I refreshed data and checked that no filters are active in table view. In my query I added a filter to just filter the missing records. In query editor the missing rows are visible, but they are not visible in table view and therefore also missing in my report. Seems like a bug in Power BI to me. See screenshot which shows the same table in query editor and in table view. Table in table view is empty.
Regards Theo
Cmcmahan
6 years agoResident Rockstar
At the top of the Query Editor, you've got a bar that tells you that the data preview is 108 days old, and may be out of sync.
Hit the refresh button, and it should fix your discrepancy.