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 Ser...
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 

amitchandak's avatar
amitchandak
Super 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

    Thank you so much!

  • 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