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.
I am trying to get an intermediate table to work, to no avail. To check it, I created a query in Access and it worked just fine. Tables come out of SQL Server in Azure. Does anyone have any insight into this? Is this not a supported feature in PBI?
Solved! Go to Solution.
Power BI .pbix is a Tabular/PowerPivot model internally. Composite Keys are not supported. See: Relationships (SSAS Tabular)
General workaround is concatenating multiple key columns into single column:
HOW TO IMPLEMENT A COMPOSITE KEY IN SSAS TABULAR MODEL
Regards,
Power BI .pbix is a Tabular/PowerPivot model internally. Composite Keys are not supported. See: Relationships (SSAS Tabular)
General workaround is concatenating multiple key columns into single column:
HOW TO IMPLEMENT A COMPOSITE KEY IN SSAS TABULAR MODEL
Regards,
@Simon_Hou-MSFT wrote:
Power BI .pbix is a Tabular/PowerPivot model internally. Composite Keys are not supported. See: Relationships (SSAS Tabular)
Regards,
Thank you for explaining this to me, this is really important to know. Because we use PBI extensively, I will redesign my tables to keep one PK, and have two or more fields of FKs. I'm glad I discovered this sooner rather than later.
Have you tried making the links bi-directional?
Thank you for the suggestion. Yes, I tried that to no avail.
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 |
---|---|
110 | |
98 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |