Forum Discussion
Vivo
10 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?
- 10 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.
Vivo
10 months agoRegular Visitor
Hello,
I'm using an Oracle database. and created the report in Power BI desktop.