cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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!

Thanks

Michellesnapshot 2.PNG

2 REPLIES 2
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.

Michelle

Helpful resources

Announcements
secondImage

Congratulations!

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!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

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