Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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, ...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    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

v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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