Data From Multiple Gateways

[Cenk]

I really need help about my powerBI project.

I have four data sources in two different locations.

1 : Excel File in Location 1

2 : MySql Database in Location 1

3 : Excel File in Location 2

4 : MySql Database in Location 2

I setup on premise gateways in two computers.

Bu I can't connect two gateways to the same peoject for a scheduled data refresh.

Is there a limit about that ?

Can you show me a way for this.

Thanx for your help.

Cenk

[V-lianl-msft]

Hi @Cenk ,

According to your description, are you using a personal mode gateway?You can have only one personal mode gateway running for each Power BI user.

You can create high-availability clusters of gateway installations.

After you create a cluster of two or more gateways, all gateway management operations apply to every gateway in the cluster. These operations include granting administrative permissions to a gateway and adding data sources or connections.

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install#add-another-gatewa... 

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-mashup-on-premises-cloud 
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Correct, any Power BI dataset can only be refreshed through a single gateway cluster.  What you are trying to achieve is impossible to do with gateways.  Use a single gateway cluster,  shared datasets or dataflows instead.

[Cenk]

Thank You for the information Ibendlin.

What if I send the data in MySql to Cloud like Azure.

Can I use it like:

1 : Excel File in Location 1

2 : MySql Database in Azure

One source from on premises gateway and the other source from Azure or another cloud location.

Thanx in advance.  

[V-lianl-msft]

Hi @Cenk ,

As far as I know, a gateway is also required for Azure MySQL, but Azure SQL Server which supports the connection Power BI without having to use the gateway in between.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin · Accepted solution]

Yes, you can go even further. If Location 1 is a Onedrive then you don't need a gateway at all.