Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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
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.
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.
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
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.