Forum Discussion
Importing only distinct rows
Hi, Power BI only imports distinct rows from the database, but I want to have all the rows to see the transactions. How can I solve this?
4 Replies
- coachVEFrequent Visitor
Check your applied steps under "Edit Queries". Maybe you removed the duplicates. Normally PowerBi will show all values from a table if there are no applied steps.
- mahesh_powerbiFrequent Visitor
I am facing precisely the same issue. Have you found a solution to this yet?
Just FYI, my data source is CDS view from SAP BW. What's yours?
Regards,
Mahesh- mahesh_powerbiFrequent Visitor
Just an update, the issue was resolved by doing code changes to the way CDS view was created by the SAP vendor. They made changes to the annotations. Now Power BI imports rows exactly as expected.
Regards,
Mahesh
- danextianSuper User
Hi,
How does your table look after navigating to the table in the database? Did you add a remove duplicates step after that?