Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
tigas31
New Member

Data Gateway to access SQL data on a separate server/virtual machine

Hi,

I have a virtual machine with a on-premises data gateway installed in order to create PBI reports in PBI Service, using dataflows. Now, I would like to access data that is located in a DB in a different server/virtual machine. This other server/virtual machine also has already it's own on-premises data gateway. 

Is it possible to configure an additional gateway to access the data on this other server and access the data using dataflows or is there any other way to achive this and access the data located in a different vitual machine?

 

Thanks in advance,

Tiago Dias

1 REPLY 1
Tutu_in_YYC
Super User
Super User

One machine requires one gateway (usually). So you have the correct setup.

If you have access to both gateways, you will see them under:

Tutu_in_YYC_1-1694530322406.png

 


Then you can map your dataset to different data sources using different gateways.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! It's time to submit your entry.

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.