Roll Forward / Use existing Model for new model

[Anonymous]

Hi

I have developed a generic model in Visual Studio (Tabular Model). I would like to use this as base as far as possible in order to apply it for other clients. The other clients would same server, but different DW DB's and excel files as source.

The DB's have the same structure so I would like to save the time having to import model, create same measures and same relationships for each new client I am creating a model for. 

[Anonymous]

Hi @v-henryk-mstf 

Not sure if I was unclear.

I was referring to essentially creating a copy of the MODEL.bim file for the new MODEL and then changing the DB source for the new model. This opposed to just changing the source of the tabular model source inside the PBIT file..

What would be the easiest way to "COPY the existing model"? Create a new project in VS, copy the code from the existing model and change the source DB name in the code before saving the changes to the code in the new model file?

@amitchandak  - any ideas here?

when I refer to VIEW CODE, I mean this:

[v-henryk-mstf · Accepted solution]

Hi @Anonymous ,

According to your description, import the new model into the existing pbix. In this case, it can only be connected in Direct Query or Live connection mode.

For how to import models created in visual studio into powerbi, please refer to the following blog:

Phil Seamark on DAX

Working with Power BI Data Models in Visual Studio Code (sqlshack.com)

After successfully importing the model, you can create measure and relationships in PowerBI. 

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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