Forum Discussion
Roll Forward / Use existing Model for new model
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.
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:
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.
2 Replies
v-henryk-mstfCommunity Support
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:
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.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: