2 Gateways, one Fabric warehouse

[BartoszBudnik]

Hi Everyone,

I have a problem with reports. 

From what I know, I can only use 1 on-premises gateway in 1 dataset in PBI. Understood.

But having MS Fabric, can I pull the data from 2 different gateways to store it in Fabric data warehouse? In this DWH, I already have data from server A, but when trying to access server B, I get such error message:

Can you please help me to solve this? From what I know, I need to have different gateways on these 2 servers, right?

I need to combine data from server A and B, have relations set in PBI model and allow these reports to refresh automatically.

Seems very strange for me that I cannot combine 2 different data sources into data warehouse, since it is one of the principal ideas of DWH - to combine data from different sources.

Any ideas?

What's important. The credentials I use for accessing this 2nd server via Fabric DataflowGen2 are the same as I use in MSSQL to pull data manually from server. And in MSSQL, it works just fine. Also, when creating PBI dataset that contains data only from this Gateway (server), I can set refresh as well. But I need to combine data from 2 gateways, and here's the problem.

Many thanks in advance for any help!

[v-pnaroju-msft · Accepted solution]

Thankyou, @lbendlin, for your response.

Hi BartoszBudnik,

We appreciate your inquiry through the Microsoft Fabric Community Forum.

Based on my understanding of the issue, utilizing separate Dataflow Gen2 instances for Server A and Server B via different gateways is the supported approach to load data into a single Fabric Data Warehouse. Since you are encountering errors while connecting to Server B via its gateway, kindly follow the steps below, which may help resolve the issue:

1. Verify that the gateway for Server B is online in Power BI Service. Ensure that port 1433 is open on the network for outbound SQL traffic.
2. Check that the credentials mapping in Dataflow Gen2 matches what is set in the gateway.
3. Confirm that you have permission to use the gateway and its associated data source.
4. Attempt to recreate the data source under Manage Gateways with the correct settings.

Once the issue is resolved, both dataflows can load into the same Data Warehouse. Subsequently, in Power BI, you can connect to the Data Warehouse, create relationships, and schedule report refreshes.

Additionally, please refer to the following link for further information:
On-premises data gateway considerations for data destinations in Dataflow Gen2 - Microsoft Fabric | ...

If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other community members facing similar queries.

Thank you.

[lbendlin]

can I pull the data from 2 different gateways to store it in Fabric data warehouse?

yes, but not in the same DF Gen2. 

[BartoszBudnik]

And I did not make them on the same DF Gen2. They were different ones. I try to make new DF with one query in it, using the other gateway and I get the same error. Like I cannot anyhow connect to this 2nd gateway via DF. 

[lbendlin]

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .