Forum Discussion

jamiehewitt's avatar
jamiehewitt
New Member
9 years ago

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

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!)

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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.