Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

On-prem enterprise gateway installation

Hi All,    I have several on-prem tabular/multi-dimensional models and I'm just trying to get my head around the Power BI Enterprise/On-Prem Gateway so that I can automatically refresh this data ni...
Need Help
Show and Tell
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    10 years ago

    Hi Anonymous,

    In your scenario, you can install on-premises gateway on a machine that can be left running all the time. Once the gateway is installed and connected, you are able to make use of it to connect to multiple on-premises data sources on multiple machines. Just make sure that the machine installing on-premises gateway and the machines having multiple data sources are joined into a same domain.

    In addition, as stated in this article, you are able to add third-party data sources such as IBM db2, MySQL and so on to the on-premises gateway.


    Thanks,
    Lydia Zhang

ankitpatira's avatar
ankitpatira
Community Champion
10 years ago

Anonymous Typically yes it should be installed on same machine as your data source. Yes computer with gateway should always be on otherwise gateway becomes invisible to power bi service. Here is the article to help you get started with data gateway.

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Hi ankitpatira,

     

    Thanks for that. I read the helpful link you provided earlier but it was a little bit vague for me. 

     

    May I ask a follow-up question? Which machine would you typically install on if you had multiple data sources? I'm just thinking about a situation where we have multiple databases on multiple machines, or if the data source was managed by a third party? (e.g. so I couldn't install the gateway on the same machine as the data source)

     

    Thanks!

     

    pbix