Forum Discussion
Duplicates after importing a Table from PostgreSQL DB [Power BI Desktop]
Hi, Issue with Power Query on Power BI Desktop (February 2022) potentially creating a few duplicates when importing a large Table from a PostgreSQL database. - Imported a Table called "s_tache"...
Fixed the issue by using a NativeQuery :
This seems to be a visual bug. Duplicates are nowhere to be seen after applying Power Query (without deleting duplicates ofc) and relations "1 to many" related to the field work just fine. Distribution is probably borking a little when the table is too large. Had issues further down the line with my PK not being unique for relations but it could be due to something else.
Will report back if anything new or interesting happens about the subject.