Report with two datasources in different gateway clusters

[LeonL]

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 databases are online, available and accessible in their own different gateway cluster. Problem is that we are not able to connect the report to the datasources. See picture:

Who can help us out on this?

Thanks in advance,

LL

[GilbertQ]

Hi there

Currently all data sources need to go via a single gateway.

[LeonL]

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

[v-lionel-msft]

Hi @LeonL ,

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.

[LeonL]

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]

Hi @LeonL ,

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.