Forum Discussion

ddelapasse's avatar
ddelapasse
Helper I
1 year ago
Solved

Can I Combine 2 Direct Query Semantic Models into one report without recreating all the attributes?

Hi,

I have 2 applications both creating semantic models that I push into PowerBI.  One has basic fundamental info with a lot of details and the second app holds calculation results based on the first.   So the structure is something like:

First Model =>  SemanticModel1
AssetId, AssetName, color, size,.... lots of other attributes

Second Model  (held in a different database but DOES have the link back to the asset)  => SemanticModel2
AssetId, CalcResult1 .... CalcResultXX

Is there any way to create one report using BOTH semantic models where I can specify the relationship myself withOUT just copying the union of ALL the attributes from both into a SemanticModel3?  I have seen there is something called a Composite model but we are ONLY using the web version (all powerbi work is done with api and the viewer is embedded inside our webapp) and the Composite seems to require desktop(?) and also seems geared for DirectQueries combined with Imports which is not my case (both are direct query).


  • ddelapasse You would need to use Desktop and essentially use DirectQuery for semantic models and analysis services to connect to both of your semantic models.

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    ddelapasse You would need to use Desktop and essentially use DirectQuery for semantic models and analysis services to connect to both of your semantic models.