Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Report with two datasources in different gateway clusters

Hi all,   We've created a report that accesses two different SQL datasources. Each SQL datasource resides on a different server with their own installed powerbi gateway.  In powerbi.com both SQL da...
Need Help
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
6 years ago
Hi there

Currently all data sources need to go via a single gateway.
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Would it be possible to put both databases in one gateway cluster? They both have different credentials 

  • v-lionel-msft's avatar
    v-lionel-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    Try to put both data source into a single gateway.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi v-lionel-msft 

       

      until now I was not able to put both machines in the same gateway since they have different credentials nor I can find documentation for this situation. 

      thanks,

      LL

      • v-lionel-msft's avatar
        v-lionel-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi Anonymous ,

         

        The credential of the data source does not affect the gateway account. You treat these two servers as two completely unrelated data sources.

         

        Best regards,
        Lionel Chen

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.