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 after running the queries. Queries are running without any notifications/warnings/errors, table seems complete in query editor but seems to lose records when loading to table view. Does anyone know how to solve this issue?Regards, Theo

I had the same issue and what worked for me was to go to each field that had numeric data, in the Visualisations pane, and make sure they are set to Don't Summarize and then Show Items with No Data.

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

I am having the same issue, the table visual has no filters but is leaving out rows. The table in power query has complete data. The table visual is very simple, I am not able to find out a cause for these missing rows.

Here I am in 2024 with this exact same issue. I've tried all the tips listed here and then some. No bueno.

You're right, Theo1403 , this is definitely a bug. Version: 2.137.751.0 64-bit (October 2024)

Missing rows in table view | Microsoft Fabric Community

Forum Discussion

Related content

Table Created with Field Parameters missing rows

Missing Table from LakeHouse

Insert row for missing repeating sequence in a table

Create rows from 2 tables

Missing rows