Failed on getting data from two different computers using Gateway

[IpCorona]

I have a problem with the data sources in the gateway cluster. I need to use two different source of data in a single report. I have a MySQL database as one of the sources, and a Excel file in another one, each one in a different computer. Both computers with On-premise Gateway installed and configured, both on the same cluster. One connect to database and the ohter one contains the excel files. The report must get data from both, however, when updates one of them fails and doesn't try in the other computer. First one (primary) is the one with the MySQL database connection, Power Bi tries to get the excel from the same one (which dones't have the file) and fails, but doesn'0t try in the one with the excel files.

If I disable the MySQL server gateway on Power Platform admin center, it will try to the excel one, but then will fails because cannot fetch data from the MySQL.  The problem is the Power Bi stops when fails to get Excel darta in the one where is not the excel files and doesn't try in the second one. It doesn't recursive search.

How I can do to get data from both sources?

[v-xulin-mstf]

Hi @IpCorona

Is your issue solved?

If the issue has been solved, please adopt the solution to help others.

Thanks!😉

Best Regards,
Link

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

[v-xulin-mstf · Accepted solution]

Hi @IpCorona,

While configuring a gateway for a composite model, you can only add different data sources under the same on-premises data gateway.

It is not supported to add two on-premises data gateways to one dataset.

For your issue, the two data sources need to be on the same host.

Please refer this about how to set schedule refresh for one dataset with multiple datasouce.

You can also refer this related blog:

https://www.cittabase.com/power-bi-tips-schedule-refresh-on-composite-models/

Best Regards,
Link

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