Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago
Solved

Create Report from Multiple Semantic Models

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 mode...
  • Anonymous's avatar
    Anonymous
    2 years ago

    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's avatar
ajohnso2
Solution Supplier
2 years ago

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.