Forum Discussion

rakisvk's avatar
rakisvk
New Member
1 year ago

Semantic model with one schema from multiple sources

Hi,

we have data for some countries in legacy solution (Synapse dedicated SQL pool) and data for some other countries in new solution (Databricks, tables managed in Unity Catalog). Let's say there is the same star schema in both.

 

We need to create one Report covering data from all the countries. My question is how to build one semantic model feeded from those two sources with one common schema?

 

Thanks in advance.

Need Help

2 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    1 year ago

    Hi rakisvk 

     

    What I will do is to create a new semantic model because I can get the data from multiple sources into a semantic model. The single semantic model could then be used for all your new reports.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi, rakisvk 

    Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

     

    Best Regards

    Yongkang Hua