Forum Discussion
missing data
Ah ok got it. Then this might be due to implicit GROUP BY in Power BI: If you're using a visual (like a table) without all columns, Power BI automatically aggregates duplicate rows. Check if "Don't summarize" is set for all columns.
Vivo is suggest looking at the actual records (as they are a handy number) and check out which one is the record missing and if this record is somehow "suspicious". If there is no filter or any Power Query transformation done which hinders the record to not be there it needs to be checked further.
Best regards!
when the records are the same, it's only showing one. I need it to show me all records, even if identical.
Ah ok got it. Then this might be due to implicit GROUP BY in Power BI: If you're using a visual (like a table) without all columns, Power BI automatically aggregates duplicate rows. Check if "Don't summarize" is set for all columns.