Forum Discussion

Ivolution93's avatar
Ivolution93
Frequent Visitor
2 years ago

On premises Gateway and Azure

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?

Azure
on premises gateway

4 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      Ivolution93
      Frequent Visitor
      2 years ago

      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's avatar
        lbendlin
        Icon for Super User rankSuper User
        2 years ago
        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.