Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

ppvinsights

Bug: postgresql dataconnector duplicates rows

Submitted by Helper III on ‎09-04-2024 07:04 AM

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

Status: Investigating

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

 

 

See more ideas labeled with:
2 Comments (2 New)
Comments
v-xiaoyan-msft
Community Support
Community Support
‎09-04-2024 11:58 PM
Status changed to: Investigating

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
Helper III
Helper III
‎09-09-2024 02:21 AM

Hi,

@v-xiaoyan-msft  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...

Idea Statuses