PowerBI, Multiple Data Sources via Gateways in Different Network/Domains

[jamiehewitt]

Hi,

I have 2 instances of the same application running in two different domains/networks.  I planned to install a data gateway in each network/domain, with a data source for each network/domain and then to combine the datasets from each data source (the query would return same structure) in PowerQuery and present as one set of information in PowerBI.

It seems that to build a report/dashboard in PowerBI desktop I need to have direct network access (TCP/IP) to the data source.  This will never work for me as there is no DMZ or intermediatte network that has access ot both networks/domains simultaneously.

Am I correct in beliving PowerBI can't help in this scenario?  Is there a way round this?

(I've collated the data using DG's and pipelines from Azure Data Factory into Azure table storage in the past but would like to avoid this overhead!)

[Anonymous]

Hi @jamiehewitt,

I'd like to suggest you try to remapping your applications to same device, then you can use one gateway to manage these data sources.

Reference link:
access shared folder on another domain

Regards,
Xiaoxin Sheng

[Seth_C_Bauer]

@jamiehewitt I believe you need to go with "overhead" route. I'm not aware of any way currently to support the multiple domain scenario as you describe. I'd love to see I've just missed something along the way from someone else who may know a way to do this.