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 :

     

v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi Anonymous 

 

Glad it works in the report.

 

It looks weird. Not sure if there is issue in the column profile view. From the first screenshot, the id 4457 is considered to appear in two rows by Power Query. You could try filtering the tae_id column to show only rows that tae_id equals 4457 and check whether the filtered result have one or two rows. 

 

Best Regards,
Community Support Team _ Jing

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Jing,
    Thanks for considering my issue. After filtering [tae_id] = 4457 only a single row comes up. 

    This really looks like a bug with the profile view. But then, what could Power Query be deleting when targeting duplicates? Really odd.

    On top of that, my DAX measures are slightly off the expected results given by SQL queries. However, the data structure was heavily manipulated and the DAX queries are relatively complex. Mistakes could be on my part but with this little bug it's hard to be sure.