Create the visualize from two data model

[thanakidt]

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.

[thanakidt]

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. 

[Anonymous]

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]

"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]

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

[amitchandak]

@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]

Could you please share the step to follow your suggestion.

[Anonymous]

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]

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