Forum Discussion
Impactful IndividualPublish Semantic Model causing Connection Break
every time i replace semantic model on prod, it breaks my connection and i have to reconfigure credentials and gateway on power bi service, due to which sometime i get emails from users that report is not visible
is there a way to replace semantic model on prod without not breaking connection without impacting users looking at report
1 Reply
- ibarrau
Super User
Hi. A good practice would be creating the connections at the Power Bi Service once and map them to the semantic model. If you have onpremise source, usually that's mandatory for gateway, but if you have cloud sources, it's not mandatory, it's a good practice.
You can go to manage gateway and connections and create one for each source of the semantic model or open the semantic model schedule refresh/configuration at gateway and sources section. You will see the sources listed, create a source for each one and assign it.
That way it will remember to always use that configuration. You can see an example here: https://learn.microsoft.com/en-us/power-bi/connect-data/service-connect-cloud-data-sources#compare-shareable-cloud-connection-to-other-connections
I hope that helps,
