Multiple Data Gateway for one report

[Anonymous]

Hi,

I am trying to create a report that consist of data that comes from several different servers that do not communicate with each other. If I create a Data Gateway for each one of the servers, am I able to point all those data gateways to one single report to trigger a refresh?

Thanks!

Daren

[v-lili6-msft · Accepted solution]

hi @Anonymous 

To my knowledge, it could not be achieved in power bi for now.

And since the dataset consist of data that comes from several different servers that do not communicate with each other, how do you create this report? If there is a separate serveral could get them together, you could install a gateway in it. or use another database as a transit point to store them and get data from it.

Regards,

Lin

[Anonymous]

Hi @v-lili6-msft 

Thanks for the response. Basically, the servers that I'm getting data from uses the same ERP system, only with different server credentials, hence, when I pull the data, I am able to simply append one server to another to get what I need. However, since it's not possible to do it in Power BI, I believe a data warehouse is what I need to look out for.

Thanks!

Daren