Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Combine multiple tabular models

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 tabu...
Need Help
Tutorial Requests
  • d_gosbell's avatar
    d_gosbell
    5 years ago

    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's avatar
Anonymous
Not applicable
2 years ago

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's avatar
d_gosbell
Super User
2 years ago
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.