Forum Discussion
Missing rows in table view
Just to double check, have you refreshed the data preview in the Query Editor recently? Just wanting to check that the data you're looking for is still in the data source itself.
If it's there, but not showing up in Table view, be sure to right click the top of the column and clear all filters. I know that I've definitely gone crazy trying to find a specific entry, but was unable to find it because I had forgotten an old filter from a few hours ago.
If it STILL doesn't show up, try filtering in ONLY the missing data from the Query Editor and see if it shows up in your visuals. It would also be helpful if you could recreate a subsection of the data and share the .pbix with us.
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