Forum Discussion

JoBen900's avatar
JoBen900
Frequent Visitor
2 years ago

Combining Multiple Semantic Models

I have a business unit that is looking to develop reports from a semantic model that incorporates three exisiting semantic models. Two of these semantic models are under the same subscription, and on...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
2 years ago

JoBen900 Not sure about Synapse. You can use DirectQuery for Power BI Datasets and Analysis Services to combine multiple semantic models in Power BI Desktop and then publish.

AlyssaC's avatar
AlyssaC
Microsoft Employee
2 years ago

Hi Greg,

I have the same question as JoBen900.

I successfully imported one semantic model (M1) in Power BI Desktop. However, when I attempted to import another one via [Get Data >> Power BI Semantic Models], I couldn't see and select any other model except M1.
Could you provide additional details about the solution? Thank you.

 

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    2 years ago

    AlyssaC Did you use DirectQuery for Power BI and Analysis Services. That said, I don't see that option any longer in the December 2023 version, you only have Power BI Semantic Models and that connects live. Soooooo...

  • tommylee2024's avatar
    tommylee2024
    Frequent Visitor
    2 years ago

    how did you import from another semantic model? 

    for me i can only direct query