Forum Discussion

viswaaa's avatar
viswaaa
Icon for Helper IV rankHelper IV
9 months ago
Solved

Edit 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 a...
Need Help
Shubham_rai955's avatar
Shubham_rai955
Icon for Super User rankSuper User
9 months ago

In 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