Forum Discussion

SB1901's avatar
SB1901
New Member
5 years ago
Solved

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.

 

 

2 Replies