Forum Discussion
Solved
missing data
when I do a query in my database I get 13 records. when I do same query in Power BI, I get 12. Can someone help in why that is happening? How can I fix it?
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.
when the records are the same, it's only showing one. I need it to show me all records, even if identical.
Mauro89
Super User
Super UserAh 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.