Forum Discussion
Dataflow using Gateway for SQL turns to a Personal Cloud Connect on publish
Hi bdnypa,
Thanks for the clarification, and it’s good to hear that using the semantic model works as expected.
Your expectation about the gateway helping with easier administration is understandable. However, the gateway mainly provides secure connectivity between Power BI and the data source, and it does not automatically abstract or handle server name changes unless the gateway data source configuration and semantic model are updated accordingly.To minimize maintenance when server changes occur, the recommended approach is to use a centralized semantic model and connect reports to it instead of directly connecting to the server. This way, if the server changes, you only need to update the connection in the semantic model or gateway data source, and all dependent reports will continue to work without requiring individual updates.
Thank you again for using the Microsoft Fabric Community Forum.
Community SupportHi bdnypa,
Thanks for the clarification, and it’s good to hear that using the semantic model works as expected.
Your expectation about the gateway helping with easier administration is understandable. However, the gateway mainly provides secure connectivity between Power BI and the data source, and it does not automatically abstract or handle server name changes unless the gateway data source configuration and semantic model are updated accordingly.
To minimize maintenance when server changes occur, the recommended approach is to use a centralized semantic model and connect reports to it instead of directly connecting to the server. This way, if the server changes, you only need to update the connection in the semantic model or gateway data source, and all dependent reports will continue to work without requiring individual updates.
Thank you again for using the Microsoft Fabric Community Forum.
Community SupportHi bdnypa,
Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you are still facing challenges, feel free to share more details happy to assist further.
Thank you.
- v-kpoloju-msft
Hi bdnypa,
Just wanted to follow up. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.Thank you.