Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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"...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Fixed the issue by using a NativeQuery :

     

simonthomas's avatar
simonthomas
New Member
2 years ago

I was struggling with the same issue:  I can confirm it is not simply a visual bug, I had a filter applied after that gave a lot of false positives because of the duplicates. Native query seems to have fixed it.

Thank you so much for your help!!