cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sameermohanty12
Frequent Visitor

Manage Relationship - Button disabled in Home

Hi Experts , Need your suggestion .

 

I m connecting to a SSAS model ( cube ) through import mode ( not Live Conection ) .

 

So i expect the Manage Relationship  button should be enabled in my Home Button , however i do see it as Disabled .

Resulting i am manually unable to do any relationship .

 

Any suggestion how to ovecome this please ?

 

Thanks

Sameer

4 REPLIES 4
Super User I
Super User I

Re: Manage Relationship - Button disabled in Home

sameermohanty12
Frequent Visitor

Re: Manage Relationship - Button disabled in Home

Hi , The link which you provided , says that i need to connect in Live Connection mode to keep all the relationship between tables that is there in the SSAS cube relationship.

 

Howeve , that is not my requirement .  I connected through Live connection , and i also connected throgh Import mode , in both of the cases my  MANAGE RELATIONSHIP button is disabled .

 

The only reasons i wanted to do some manual relationship , because , while i try to drag fields from various tables in power BI , it says :  The visualization cant be displayed because power Bi can not detemine the relationship .  Even thogh in the Cube the relationship is alreay there .  So i m literally scratching my head , and do not know how to proceed on . I want to get rid of this issue -  CANNOT DISPLAY THE VISUAL , BECAUSE POWER BI CAN NOT DETERMINE THE RELATIONSHIP .

 

Thanks Again

Microsoft V-lianl-msft
Microsoft

Re: Manage Relationship - Button disabled in Home

 
SSAS is a complete model of data analysis.
If you choose a Live Connection, it means that the entire external model is loaded in and can not be converted into a composite model and related to other tables in power bi.
You can select import mode for all, or create tables and establish relationships in SSAS and use Live Connection.
 
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
sameermohanty12
Frequent Visitor

Re: Manage Relationship - Button disabled in Home

Hi @V-lianl-msft :  Does that mean , in Power Bi when i am connecting with import mode to a cube , still I will not be able to manage relationship in power bi itself ?  

 

Every relationships should be done in the SSAS cube itself ? 

The reason i am curious to know , because I was under the impression that , if i connect to SSAS cube in IMPORT mode , then i should have the previlege to edit the relationshop ( manage relationship ) at the power bi end .   Am i wrong here ?  

 

Please provide me a clear picture as i am confused .   Also please restirict your answer to       :   SSAS cube    Vs   Power BI import Mode   Vs  Manage Relationship.       Is it possible to Manage relationship in Power BI import mode while connection to SSAS cube ?  

 

Many thanks for your time .

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors