Forum Discussion

jasonyeung87's avatar
jasonyeung87
Icon for Helper V rankHelper V
4 years ago

Can't connect to on prem data gateway for SQL Server

Hi,   I've developed a Power BI report on desktop and have published this to Power BI Service. This report accesses an on prem SQL Server. I've installed the On prem data gateway on the server and ...
Need Help
jasonyeung87's avatar
jasonyeung87
Icon for Helper V rankHelper V
4 years ago

Hi otravers ,

 

Thanks for the info. I ran the Networks ports test on the app that is installed on the server. It shows it's able to connect to all the ports. 

 

Sincerely,

 

Jason

 

  • otravers's avatar
    otravers
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Can you monitor CPU and RAM usage on your server when you launch a refresh? It's recommended to put the gateway on a separate server/VM so that it doesn't compete for resources with the database. If you do move your gateway to a different server, make sure it's on the same local network as your database to minimize latency.

    • jasonyeung87's avatar
      jasonyeung87
      Icon for Helper V rankHelper V
      4 years ago

      otravers ,

      I monitored the usage while it attempts to refresh. The CPU / Memory usage doesn't really spike. The server itself doesn't get much usage on a day to day basis. It's a data warehouse and is mainly used for Power BI reports.


      I tried to create a new data source in the gateway with the same config as the original, but it also couldn't connect. It seems that it's only if the data source type is SQL Server that is giving this problem. If the data sourcve is Analysis Server, it connects fine and has been for years.

       

      Jason