Create Report from Multiple Semantic Models

[Syndicate_Admin]

Hello

I currently have 3 reports published on the services, each with its respective semantic model. Is there currently any way to create a report based on these 3 already published semantic models? Or any alternative to be able to integrate the 3 models?

Thank you

[Anonymous · Accepted solution]

Hi ALL
Firstly @ajohnso2  thank you for your solution!

And @Syndicate_Admin for you problem,we can try to integrate the models of the three data using dataflow.

1. Connect to different data sources in dataflow.

2. Connect to dataflow in desktop, create report, then publish to service.

3. In the workspace, you can see the data of the three models being integrated.

The following Dataflow-related documentation is intended to help you.

Configure and consume a dataflow - Power BI | Microsoft Learn

You can also connect to different data sources in desktop, organise the relationship between tables, you can achieve the effect of semantic model integration, the overall effect is similar to dataflow.

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[ajohnso2]

You cannot write a report over 3 seperate models however you can build a new model bringing in the elements from the 3 models with a direct query to those published models.