Forum Discussion
Helper IVEdit relationship in Power BI symantic models
Hi All,
I am building a report using the Feature Usage and Adoption semantic model, where I need to list all workspace names along with the reports inside them.
I am using the tables Fabric Items and Workspaces, but the relationship between them is showing as inactive, and Power BI is not allowing me to activate it. Because of this, I am unable to use fields from both tables in a single visual.
Could you please advise how we can make this relationship active, or if there is an alternate approach to achieve this requirement?
Hi viswaaa ,
I think you cannot activate the relationship between Fabric Items and Workspaces directly in the Feature Usage and Adoption semantic model.
Please refer below link for details :
https://learn.microsoft.com/en-us/fabric/admin/feature-usage-adoption
Please give kudos or mark it as solution once confirmed.
Thanks and Regards,
Praful
5 Replies
- danextian
Super User
Hi viswaaa
That behavior is expected when two tables are connected through a relationship, whether directly or indirectly. Power BI allows only one active relationship at a time. An indirect relationship occurs when two tables are linked through a third table, causing them to still interact even without a direct relationship between them.
- Praful_Potphode
Hi viswaaa ,
I think you cannot activate the relationship between Fabric Items and Workspaces directly in the Feature Usage and Adoption semantic model.
Please refer below link for details :
https://learn.microsoft.com/en-us/fabric/admin/feature-usage-adoption
Please give kudos or mark it as solution once confirmed.
Thanks and Regards,
Praful
Shubham_rai955In Power BI semantic models, if a relationship between two tables (like Fabric Items and Workspaces) is inactive and cannot be activated, usually it's because there is already another active relationship between these tables or model structure does not allow it.
Solutions:
Check if another relationship is already active between the tables. Power BI only allows one active relationship between two tables; deactivate the other one if you need to activate a different one.
If activating is not possible, use the inactive relationship with the USERELATIONSHIP function in your DAX measure. Example:
Measure = CALCULATE([Your Measure], USERELATIONSHIP('Fabric Items'[WorkspaceId], 'Workspaces'[WorkspaceId]))This way, you can use both tables in visuals by building measures that reference the needed relationship even if it's inactive.
If neither approach works, try combining both tables in Power Query with a merge/join, or create a composite key in both tables for a new relationship.
You can list workspace names with their reports by either activating the needed relationship (if possible) or by using DAX with USERELATIONSHIP for calculations
v-karpurapudCommunity Support
Hi viswaaa
I would also take a moment to thank Praful_Potphode , Shubham_rai955 and danextian for actively participating in the community forum and for the solutions you’ve been sharing in the community forum.
I hope the information provided help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you
Best Regards,
Community Support Team- v-karpurapud
Hi viswaaa
We have not received a response from you regarding the query and were following up to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank You.
