Bug: postgresql dataconnector duplicates rows

[ppvinsights]

Hi, not sure if my post in the pbi desktop community was the right place to post. So as far as I can tell my example is a bug in the postgresql dataconnector. Here is my post:

https://community.fabric.microsoft.com/t5/Desktop/Row-Duplication-when-using-postgreSQL-connector/m-...

Thanks for help and feedback.

Holger

[Anonymous]

Hi @ppvinsights ,

Please ensure that the transformations you're applying in Power BI are being folded back to the PostgreSQL database. You can do this by right-clicking on each step in the Power Query Editor and selecting "View Native Query" to see if the query is being folded.

Try modifying or removing the index on the "id" column to see if it affects the duplication issue. This might help if the index is causing the problem.

Best regards.
Community Support Team_Caitlyn

[ppvinsights]

Hi,

@Anonymous  thanks for the answer. The query is folded back. And somewhere here is the bug! I cannot remove the index - it is the primary key index!

So IMHO it is a bug in the postgres sql-connector which has to be fixed. Would be great if anyone can reproduce my error. All the files necessary are in my first post...