Forum Discussion

RenataOG30s's avatar
RenataOG30s
Frequent Visitor
4 years ago
Solved

Gateway slowing system performance.

Hello folks,

 

Does anyone got experience in configuring Power BI gateways? For a client, I have asked their IT provider to install an on-premises gateway on the server hosting their CRM (a SQL Server-based estate management system). They report: "...that the gateway is causing performance issues as it is trying to keep a live link to the system, 100% of the time hence slowing performance of the system for the finance team".
Would be a separate server for Power BI only resolve the problem?
 
Thanks in advance,
R
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    RenataOG30s , Gateway should be on a separate system and should have access to the database. In case if there are too many queries on live database, then you should consider image/copy database for that 

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    RenataOG30s , Gateway should be on a separate system and should have access to the database. In case if there are too many queries on live database, then you should consider image/copy database for that 

    • RenataOG30s's avatar
      RenataOG30s
      Frequent Visitor
      4 years ago

      Hi, amitchandak  would you have more specific advice, instructions on that, please? 

      Unfortunately, I'm on my own this and I need to explain to the IT department what needs to be done.

      Many thanks,

      R

    • RenataOG30s's avatar
      RenataOG30s
      Frequent Visitor
      4 years ago

      Hi, amitchandak is it recommended to install the gateway on a different server? Or could I leave the data source and gateway running in the same machine if the query is on the database copy instead of the live database? 

      Thanks,

      R