Connect datasets to 2 gateways

Thanks very much for your reply.

I am using the same credentials in the Power BI Desktop as the service and gateway.  Locally I do not have direct access to the Oracle database.  I have a copy of the Oracle schema and tables locally that I can connect to and import the data from.  This issue comes when I publish.

If I connect to the SQL Server database in one report and connect to the Oracle database in a separate report I can connect to each of the databases and import the data without an issue.  The problem arises when I try to connect to both in the same report.  As you can see in the screenshot from my previous post, there are 2 gateway connections possible.  One has the SQL Server connection successful (green) and the Oracle one not (red) while the other gateway has the Oracle connection successful (green) and the SQL Server one not (red).  I can't include them in the same gateway as the SQL Server database is connected to an on-prem gateway locally.  The Oracle database is connected to a vendor's AWS server.

It seems like the dataset can only connect to one gateway.  That is the reason for my question.  Can I connect the dataset from the one report to 2 databases where one has a connection through one gateway and the other has a connection through a different gateway?

Hope this provides a little more insight and detail into my problem.  I appreciate your help.  Thanks,

Fernando