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: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

ppvinsights

Bug: postgresql dataconnector duplicates rows

Submitted by Helper III Wednesday

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:
1 Comment (1 New)
Comments
v-xiaoyan-msft
Community Support
Community Support
Wednesday
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

 

 

Idea Statuses