Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Power Bi | Analysis Services | Working with Mixed Model

Hello,   I am working with an Analysis Services Model which works on Live Connection.   With the December Power Bi Update we can add local tables also and make the model mixed.   So in my mixed...
Data Protection
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous 

    You may try make change to live connection mode for Analysis Services to change mode to DirectQuery.

    Blog: Using DirectQuery for Power BI datasets and Azure Analysis Services (preview)

    Then you can use datasource from live connection and local at the same time.

    Try to build a new calculated table.

    Table = ADDCOLUMNS(GENERATE('Local Table','Live Connection'),"IncurredAboveDeductible",IF([Incurred]-[Deductible]<0,0,[Incurred]-[Deductible]))

    Result is as below.

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

What have you tried so far?  How did you connect the two data models?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello,

     

    I have connected to the live connection model. And then added a local table with a SQL Query from Azure Analysis Services.

    Just tried creating relationship between my local table and one table from Live Model. Could only create Many-Many and not Many-One like i wanted.

     

    Could not create a relationship between the tables i have posted in my question as there are no matching columns.