Forum Discussion
Get Data from Postgres does not import relationships correctly
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.
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.
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.
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.
