Forum Discussion
SB1901
5 years agoNew Member
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 separat...
- 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.
aj1973
Community Champion
5 years agoHi 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