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 Data Visualization World Championships is back! It's time to submit your entry. Live now!

RMurtagh

PostgreSQL Connector - Left Join Dropping Rows

Submitted by on ‎08-08-2023 11:31 AM

Issue that appears to have been brought in after a previous update where if you do any transformations (in my case Left Outer Join) using data direct from PostgreSQL connector, it will drop rows from the left table. Appears to have been a bug a few years ago that I believe has been reintroduced

Status: Investigating
See more ideas labeled with:
2 Comments (2 New)
Comments
Anonymous
Not applicable
‎08-09-2023 12:47 AM

Hi  @RMurtagh ,

 

Can you provide detailed version information so we can reproduce the issue? We'll get back to the product team as soon as it's acknowledged as an issue!
Thanks in advance!

 

Best regards.
Community Support Team_Caitlyn

RMurtagh
Frequent Visitor
‎08-09-2023 01:05 AM

Hi @Anonymous,

 

Sure! My version of Power BI is 2.119.986.0 64-bit (July 2023). From my bug queue I have my side I first saw the issue earlier this year but couldn't identify why.

PostgreSQL version: PostgreSQL 13.11 (Ubuntu 13.11-1.pgdg20.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.1) 9.4.0, 64-bit

 

Using the PostgreSQL connector, imported tables and then performed left outer joins which is where I notice data loss after loading it into the main model .

 

Let me know if you need anything else. Thanks!

Idea Statuses