Forum Discussion
Multiple data sources, gateway problems
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.
- Anonymous5 years ago
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
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.
2 Replies
- AnonymousNot applicable
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
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. - aj1973Community Champion
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