Combine multiple tabular models

[Anonymous]

Hi Experts,

I've been searchinf for a while for this, and sorry if this not the right place to ask. Basically I would like to know if is possible to combine in a MDX query, tables from multiple tabular models? Let's say I have 3 different models for each country with the same table structure [number of columns, name of columns, etc] but different information. What I'm trying to achieve is combine in one table, those 3 tables, sometime like:

Evaluate ( 
Var Table1from1tabularModel = ADDCOLUMNS(Summarizecolumns(Table1[state]),"Country","Country A") 
Var Table2from2tabularModel = ADDCOLUMNS(Summarizecolumns(Table2[state]),"Country","Country B") 
Var Table3from3tabularModel = ADDCOLUMNS(Summarizecolumns(Table3[state]),"Country","Country B") 
Return 
UNION (Table1from1tabularModel, Table2from2tabularModel , Table3from3tabularModel ) )

What is the best approach for this?

[d_gosbell · Accepted solution]

Sorry, but this is not currently possible. Technically your example is a DAX query, but both DAX and MDX can only execute against a single model.

Microsoft has announced that they are currently working on a new composite model feature for Power BI that will allow you to link multiple models together so this should allow for scenarios like the one you have outlined. But this is not available yet, it is scheduled for a preview release next month, but I would not expect it to be fully publically available until sometime next year.

[Anonymous]

@d_gosbell  - do you perhaps know if this is possible yet?

I am trying to merge/append/combine two similar fact tables from two different datasources (two different data warehouses), either in the same or different tabular model.

[d_gosbell]

---

@Anonymous wrote:

I am trying to merge/append/combine two similar fact tables from two different datasources (two different data warehouses), either in the same or different tabular model.

---

You should be able to do this in your Power Query / "Get Data" step. It's just not possible with an MDX/DAX query.