2 Gateways, one Fabric warehouse
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!
