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 ,
I just wanted to check if the issue has been resolved on your end, or if you require any further assistance. Please feel free to let us know, we’re happy to help!
Thank you
Chaithra E.