Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Inactive relationships using SSAS Live Connection

Hi Community,

I have a situation that appears when I use Live Connection to a SSAS cube.  As I go and slice/dice using various visualizations, I unable to provide needed visuals as I have inactive relationships that were detected in the data model in Desktop.

My research shows that I may be able to use the DAX expression using USERELATIONSHIP.  However, I have tried a few expressions and am not getting the desired results.  So:

1.  Should I be attempting to "fix" the inactive relationships in Power BI Desktop OR have a DBD help do this is the tabular model?

2.  If I can do the fixes in Power BI Desktop (which ideally I'd like to do), is there someone in the community that is well-versed in this area that can help me?  I'd provide all the details.

I have 2 projects on hold due to this situation. 😏


Appreciate any insight!


Michellesnapshot 2.PNG

Super User II
Super User II

@mmiller32 wrote:

1.  Should I be attempting to "fix" the inactive relationships in Power BI Desktop

You cannot alter the relationships in a SSAS cube from Power BI Desktop.


Your only options are to either get the relationships fixed in the SSAS solution. This has the benefit that any future reports built of this model will have the same fix already in place.


Although it looks like there are some circular relationships there so activiating the relationships you've highlighted might require other relationships in the model to be made inactive to avoid ambiguity. The way to resolve this is to create measures using USERELATIONSHIP or CROSSFILTER to control the relationship activation. It's probably best to discuss your requirements with the model developer so that they can alter the solution appropriately.

Thank you for responding. Yeah I'm going to go back to the DBD to hopefully work it out with him.


Helpful resources



We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.


The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors
Users online (1,151)