Forum Discussion
Vivo
7 months agoRegular Visitor
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?
- 7 months ago
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.
v-echaithra
7 months agoCommunity Support
Hi Vivo ,
May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.
Thank you.