Forum Discussion

thanakidt's avatar
thanakidt
Frequent Visitor
5 years ago

Create the visualize from two data model

Hi guy,

 

Please advise, I would like to create the visualize from two data model in difference tab and compare that both visualize to overall tab, what shall I do?

 

Remark: we have use the analysis service to build this data model.

 

Need Help

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Would you like to connect 2 different  AAS tabular models  from PowerBI  to build 2 different visualizations in  2 different pages ?

    we can  only connect 1 tabluer model at a time .

     

    • thanakidt's avatar
      thanakidt
      Frequent Visitor
      5 years ago

      if that it impossible for this time, Do you have workaround to combine 2 AAS in one pbxi?

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    thanakidt , if It is a live connection then you can not. But if these are two models in the same pbix file. The you should able to copy visual on same page and check data together.

     

    What do mean by two datamodel here

    • thanakidt's avatar
      thanakidt
      Frequent Visitor
      5 years ago

      Could you please share the step to follow your suggestion.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi thanakidt ,

    Do you want to copy the visuals on "MONTHLY" and "Page 1" page  into "OVERALL" page? If yes, you can refer the following documentation to get it.

    Copy and paste a report visualization

    In addition, you can refer this documentation when you want to copy and past across report. But the precondition is that these reports exist the same data tables...

    Copy & paste between Power BI Desktop files

    Best Regards
    Community Support Team _ Rena Ruan
    If this post helps, then please consider Accept it as the solution to help the other members find it more.

    • thanakidt's avatar
      thanakidt
      Frequent Visitor
      5 years ago

      "MONTHLY" create from 1 AAS(sales)

      "Page 1" create from 1 AAS(stock)

      And combine the visualize to "OVERALL" 

      that I would like to do.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi thanakidt ，

        From your screenshot, it seems that you are connectting to AS using live connection mode. When connecting to AS in live connection mode, you are only able to connect to a single SSAS instance. So if sales and stock you mentioned are from different AS models, it will no longer be able to combine into same report...However, it is possible if you use the import mode to connect to AS.

        Best Regards

  • thanakidt's avatar
    thanakidt
    Frequent Visitor
    5 years ago

    Thank you for all guy,

     

    Let me explain more about my Data model , I have two cube model in AAS (1 Sales model, 1 Stock model) So I would like to display the date by visualize in 1 power bi (pbix), currently I can connected ONLY 1 AAS but cannot add more AAS to pbix.

    please advise.