Forum Discussion

georgejoy's avatar
georgejoy
New Member
6 years ago

Get Data from Postgres does not import relationships correctly

I am trying to import a medium size PostGres database (http://drugcentral.org/ActiveDownload) into PowerBI. It has 53 tables and many foreign key relations between them. I expect the Postgres connect...
Need Help
georgejoy's avatar
georgejoy
New Member
6 years ago

Some primary keys are the same and others are not. I don't think this matters. The foreign key relationships are part of the database definition and queryable by the PowerBI Postgres connector. Curiously the  PowerQuery editor seems to understand the relationships between tables so it is not clear why they don't show up after Load is complete.

v-xicai's avatar
v-xicai
Community Support
6 years ago

Hi georgejoy ,

 

You may go to File ->Options and Settings ->CURRENT FILE ->Data Load, tick the option "Autodetect new relationships after data is loaded", then restart the Power BI Desktop to take effect of this change.

In addition, make sure the name of primary key and foreign key are the same .

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • georgejoy's avatar
    georgejoy
    New Member
    6 years ago

    I don't have control of the primary key and foreign key names. If I am going to rename all the relationship columns, I may as well just create the relationships manually.  There are probably around 100  curated relationships so I would prefer not to create them manually.