Multiple data sources, gateway problems

[SB1901]

Hi everyone,

I'd really appreciate your help with a problem I am experiencing connecting two ODBC data sources together in one Power BI report. The two data sources are accessible via two separate gateways in separate virtual machines. Gateway A stores data source 'System' and Gateway B stores data source 'survey_unicode'.

When trying to configure the data refresh, both gateways seem to want to connect to both data sources. I would have thought each gateway below would have one data source.

I'm really confused and haven't seen a similar post. I'd really appreciate some help on the best way to combine to remote data sources into one report. I've tried connecting to another Power BI dataset in the same file but see the message saying that's not possible.

[Anonymous · Accepted solution]

Hi @SB1901 ,

All the data sources for a dataset have to belong to the same gateway.

And As @aj1973 said,  it is not possible to configure more than one on-premise data gateway on the same Windows server.

Refer to:

https://community.powerbi.com/t5/Service/Multiple-Data-Gateway-for-one-report/m-p/868082

https://powerbi.microsoft.com/en-us/blog/multiple-data-source-definitions-on-the-on-premises-data-ga...

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

[aj1973]

Hi @SB1901

Not possible, only one Gateway should be used.

Check this out 

https://community.powerbi.com/t5/Power-Query/Can-we-get-data-from-2-different-databases/td-p/132168