Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Relationship model: PostgreSQL and composite keys

Hello everyone,   I've got a PostgreSQL connected to PowerBI and my db looks like this - reduced to the relevant parts:   Table 1: Its id, let's call it id1 is the Primary Key. Table 2: id1 is t...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

    Regarding your question, in Power BI, you need a column to establish a relationship between tables (compound keys containing multiple columns are not supported), you need to merge all the columns contained in the compound key into a single column. You can do this in Power Query.

    You can then publish the modified .pbix file to Power BI Service to share it with your users, and they won't have to modify it manually.

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

Regarding your question, in Power BI, you need a column to establish a relationship between tables (compound keys containing multiple columns are not supported), you need to merge all the columns contained in the compound key into a single column. You can do this in Power Query.

You can then publish the modified .pbix file to Power BI Service to share it with your users, and they won't have to modify it manually.

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