Forum Discussion
Shared Semantic Models not syncing
Thanks, based on the screenshot, it doesnt look like you are making a live connection to an existing semantic model. Live connection is the common mode for reports sharing the same semantic model, where no further semantic models would be created.
Looks like what your users are actually doing is creating a local model based on an existing semantic model, this technique is called Chaining which results in either a DirectQuery or even possibly a Composite model if you user end up adding more data sources to the model. That means there will be 2 semantic models, ie the original and the newly created.In regards to "automatically connects to table added later", im testing this. Will report back.
TDargan
The "automatically connects to table added later" only valid in Power BI desktop, ie when you hit refresh in power bi desktop, it will scan for new tables in the existing semantic model in power bi service and bring it into you local model.It doesnt apply to chained semantic models that have been published to power bi service.
If the idea is to have reports only connected to 1 semantic model that you manage and utilize any new changes/update to the model, you might have to adjust your approach, ie do not let users create a local model after connecting to the semantic model in the service (chaining).
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models#chaining
Hope this helps
Hi,
can you help me locate the checkbox you mentioned? I dont see it when im connecting to a semantic model. A screenshot would be appreciated.
Hi,
Here you go. You get to it by clicking on Settings after choosing your semantic model.Thanks, based on the screenshot, it doesnt look like you are making a live connection to an existing semantic model. Live connection is the common mode for reports sharing the same semantic model, where no further semantic models would be created.
Looks like what your users are actually doing is creating a local model based on an existing semantic model, this technique is called Chaining which results in either a DirectQuery or even possibly a Composite model if you user end up adding more data sources to the model. That means there will be 2 semantic models, ie the original and the newly created.In regards to "automatically connects to table added later", im testing this. Will report back.
TDargan
The "automatically connects to table added later" only valid in Power BI desktop, ie when you hit refresh in power bi desktop, it will scan for new tables in the existing semantic model in power bi service and bring it into you local model.It doesnt apply to chained semantic models that have been published to power bi service.
If the idea is to have reports only connected to 1 semantic model that you manage and utilize any new changes/update to the model, you might have to adjust your approach, ie do not let users create a local model after connecting to the semantic model in the service (chaining).
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models#chaining
Hope this helps
