On premises Gateway and Azure

[Ivolution93]

Hello

We have all our reports connect to data on our server which has SQL server on it.

We have an on premises gateway on our server for the reports to link to the server.

Do we also need azure or is azure something different?

[v-xiandat-msft]

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.

[Ivolution93]

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]

So our on premise gateway is on our SQL server

Don'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.

[lbendlin]

You posted this in the Report Server section.  Report Server is for on-premise consumption.  Please confirm your setup.