Get Data from Postgres does not import relationships correctly

[georgejoy]

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 connector to Get Data into PowerBI with the relations preserved accurately so I can start to use PowerBI effectively. Tables appear to be imported, but foreign key relationships are partial.

Postgres importMissing a ton of relationshipsExample foreign keys for table "Structures"

Note that PowerQuery editor shows the table relationships but not the Loaded data set (looks like they just got dropped silently somewhere)

[lbendlin]

Are the field names different between primary and foreign keys? 

If you have a PRO license you should raise a ticket to Microsof to have them confirm or clarify the expected functionality.

In the meantime you can adjust the Power BI data model according to your PostgreSQL relationships.

Personal opinion: 53 tables is a sure sign that your data model is too complex to be useful.

[georgejoy]

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]

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]

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.