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?
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
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