The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
User | Count |
---|---|
5 | |
5 | |
2 | |
2 | |
2 |
User | Count |
---|---|
10 | |
7 | |
4 | |
4 | |
4 |