Manage Relationships disabled

[gbts]

Hello, all!

I'm a new user and am working my way through the videos in Guided Learning while looking around in Power BI Desktop.  I am stuck because I've gotten to the part about Managing Relationships (https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-2-2-manage-data-relationships/), and those sections are not available in my Desktop app.  It's greyed out at the top, and not available on the left side of the screen.  (See visuals below.)

I do have data.  It is available on the right side under Fields.

I am working with sales data, and I want to be able to show ONE row per won quote, but a varying # of products within that quote.  I've only been able to get this info to show with multiple rows per quote (one row per product).  I'm hoping that managing my relationships will help with this, but I can't get there.  😕

Thank you in advance!

[picnic]

Same issue here. Manage Relationships is always greyed out. I do not see SSAS connection in Power BI desktop, where this is to be checked? 

[v-jiascu-msft]

Hi @gbts,

Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

Best Regards!
Dale

[v-jiascu-msft · Accepted solution]

Hi @gbts,

Did you establish a live connection to SSAS? If so, your scenario is expected. If you want to some exercises, you can change live connection to import mode. 

Best Regards!

Dale

[gbts]

I do see that I have a Live connection, thanks!  But I cannot figure out how to change the connection.  Can you help with that?

[Zoe]

Hi there,

I'm curious about this - I'm having the same issue as the original poster (manage relationships greyed out/disabled) yet when I try to set up my data from SASS to import instead of a live connection I get the "not enough memory" error as detailed in:

https://community.powerbi.com/t5/Desktop/Not-Enough-Memory-Error/td-p/193818

Following the steps here doesn't help me, so I've raised an internal ticket to see if our IT guys might be able to check the memory issues specifically, but any other suggestions/fixes/options I could try to enable the manage relationships option?

Thanks.

[v-jiascu-msft]

Hi @Zoe,

This isn't an issue. SSAS is a complete model of data analysis. You can apply the changes of the relationship in the SSAS model.

Best Regards!

Dale