Multiple Gateways

[fbarini]

Hello, my company (myself included) is farily new at Power B.I..  We have had a consultancy to make us our first B.I. Dashboard by importing SAP data in the end of 2020. Recently, I finished a new Dashboard (using other database - MySQL) and just published it, but I'd like to set up the auto-refresh.

The thing is: me and the folks are afraid of building a new gateway on the same server and erase/damage the previous one made by the consultancy.  Is our fear applicable or not? If not, is there any other issue we should pay attention to?

At last, is it mandatory to publish the dashboard from the Server machine or do I just need to configure the gateway from it?

Thanks in advance.

[ibarrau · Accepted solution]

Again. If you have one server and one gateway don't install a new one. Just configure it in Power Bi Service with the admin account that installed the gateway. I think you can login in the gateway in case you don't remember that account.

If you want to paralell traffic and administrate all flows in single place it's a good idea to install a new gateway in a different server on the same network. Be sure to read how to install and build the cluster because you need to do stuff before installing. As same as before, you will still need to go in the gateway settings in Power Bi Service to configure the new mysql source.

You can publish your report from any computer besides the gateway servers. The configuration for it is completely out of your environment. That's why I have mentioned to install the mysql driver on the server and restart it to help the gateway understand its conection. If you don't do that you won't be able to configure the source in Power Bi Service.

I hope it's clearer now 🙂

[fbarini]

Thank you very much! It was quite clear from the beggining, it's just that both me (developer) and our infrastructure team are very new to the power bi enviorement. Thanks again for taking your time on helping

[ibarrau]

Hi. You shouldn't install two Gateways on the same machine. You can just use that one and configure the new source in Power Bi Service. In mysql case you might need to install a driver to let the computer understand mysql connections and restart it.

Remember, you can add admin accounts on Service in case you want more than one account to manage that.

In addition, just for the heads up, even if you are using a different server, you can create a cluster of gateways instead of building different ones. 

I hope that helps,

[fbarini]

In other words, I should be able to configure the "new" gateway alongwith the "old" gateway, making a cluster, correct? This won't affect the "old" gateway, correct? Even though the datasets published are from two different sources and people.

Also, does the data needs to be published from the main Server to configure the Gateway or is it possible to do it even though it was published by my User/PC?