Forum Discussion
On premises Gateway and Azure
Hi Ivolution93 ,
Whether you need Azure depends on your specific requirements and business needs:
- Stay On-Premises: If your current setup meets your needs and you prefer to keep your data on-premises, you can continue using your existing SQL Server and gateway.
- Consider Azure for Scalability and Flexibility:
- If you anticipate growth, need scalability, or want to explore cloud-based solutions, consider Azure.
- Azure provides benefits such as automatic backups, high availability, and the ability to scale resources up or down as needed.
- It also allows you to offload maintenance tasks to Microsoft, freeing your team from server management.
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
So our on premise gateway is on our SQL server which is on a network.
All of our current reports go through this on premise gateway and refresh through this.
i am getting told that azure then works with the on premises gateway. however i thought azure was a cloud database totally seperate to the on premisis side of things
- lbendlin
Super User
So our on premise gateway is on our SQL serverDon't do that. They will fight for compute and memory resources. Use a separate VM.
You don't need a gateway for an Azure data source UNLESS you are trying to merge it in Power Query with an On-Prem data source. In that case your Azure data source MUST refresh through the gateway. So - avoid at all cost.
