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: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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