Forum Discussion

anonymouseke's avatar
anonymouseke
Frequent Visitor
2 years ago

Problems with making a multitenant setup for embedded Power BI

I am trying to implement the `app owns data` embedded flow for power Bi. I have been succesfull in creating a report, publishing it and displaying it on a webpage with the embed url, token and stuff....
Dataflow
Need Help
Show and Tell
anonymouseke's avatar
anonymouseke
Frequent Visitor
2 years ago

Hi GilbertQ ,

 

Thank you for your quick response! Now I am wondering how I would be able to combine multiple databases into 1 semantic model? I would also like it to be auto refreshed. We are aiming at about 40 tenants with quite a lot of data, so I don't really know how big 1 semantic model can get. You got any insights to this?

 

EDIT

Also we should be able to programatically add the new data to the model, is this possible? Adding a datasource with a connectionstring, doing the transformations, updating the semantic model and publishing all via the rest api?

 

Kind regards

  • GilbertQ's avatar
    GilbertQ
    Super User
    2 years ago

    Hi anonymouseke 

     

    Depending on how you model your data you could have a lot of rows in your semantic model (dataset) that will not consume a significant amount of memory.

     

    I think you could find a way to use a control table which has got all the data sources. You then use this control table to loop through the databases to get the data into your semantic model.