Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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).
Solved! Go to Solution.
@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.
@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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
3 | |
2 | |
1 | |
1 | |
1 |