Forum Discussion
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...
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.