Importing only distinct rows

[Anonymous]

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?

[danextian]

Hi, 

How does your table look  after navigating to the table in the database? Did you add a remove duplicates step after that?

[mahesh_powerbi]

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_powerbi]

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

[coachVE]

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.