Forum Discussion
Multiple Data Gateway for one report
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
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
2 Replies
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
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