Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm trying to connect two tables with 2 columns as a key
but it is not possible to select more then one column for a relationship.
*I dont want to create a new column that contains this 2 columns value in one cell
thanks,
Solved! Go to Solution.
Hi, composite keys are not supported in Power BI. As you suspected, you would need to create a new column in each data source that contains the combined values, then use this as the relationship column.
Here are previous threads on the topic:
And here is the suggestion on the ideas site if you'd like to comment/vote:
Thanks,
Sam Lester (MSFT)
Hi, composite keys are not supported in Power BI. As you suspected, you would need to create a new column in each data source that contains the combined values, then use this as the relationship column.
Here are previous threads on the topic:
And here is the suggestion on the ideas site if you'd like to comment/vote:
Thanks,
Sam Lester (MSFT)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |