Forum Discussion
Semantic Model
Hello !
Try to connect to the PBI semantic model viaSSMS using the XMLA endpoint to manage, query, or script the model. You can copy the workspace connection string from PBI workspace settings.
Hi Ania26
In Power BI Desktop, create a new file, and connect to your existing Semantic Model.
If you then add any new data source (e.g. Connect to another Semantic Model, Use Get Data to connect to another source etc), Power BI will ask you to "Add a Local Model":
This will create a new Semantic Model, which is the combination of your old semantic model, plus any changes you make to it.
If you make changes in the old model, they will automatically feed into and become available in the new model when you refresh the new model.
If you make changes in the new model, e.g. adding new tables or measures like you are asking, they will only be available in the new model, not the old one.
Hope that helps!
_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data