Duplication of ID columns

[Anonymous]

Hi,

I do not know whether anybody has experienced the below behaviour of Power BI. 

I am fetching data from PostgreSQL. In original database structure the tables are linked by respective “id” columns. Whenever I am fetching the data (importing table) into power bi file, instead of 1 id column it is showing me 2 id columns in the below format “TABLE (COLUMNNAME) 2” in short it is duplicating the linked table with ID Column.

What can be the reason of this behaviour of power bi?

[az38]

Could you show data load query from advanced editor ?

[Anonymous]

Hi @az38 ,

The below screenshot is till Navigation step.