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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Sofinobi
Helper IV
Helper IV

Data gateway (personal mode) in 2 differents servers (not in same location)

good morning all,

 

please, i want to know, if it is possible to install 2 data gateways in 2 different SQL server ( from our 2 different production sites) and connect them with my username to schedule refresh in power bi service.

 

thank you all

1 ACCEPTED SOLUTION
aj1973
Community Champion
Community Champion

Yes I see your issue, It's a personnal Gateway and Power BI service(Logged in with your user name) can only accpet one Personal Gateway at a time. And a personal Gateway can only be used by its owner.

Can you install a Standard Gateway on the Server n 2?

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

View solution in original post

10 REPLIES 10
aj1973
Community Champion
Community Champion

Hi @Sofinobi 

Yes it is possible as long as they are installed in 2 different servers. Give it a try

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

hi @aj1973  thank you for your answer,
i installed the gateway in the differents servers (VMs), but when i go in power bi service i have only one gateway connection, i haven't 2. as this image from microsft, that i can choose for each report wich gateway connexion to schedule the refresh from.
in my case, i have only one 

i need like this result
Capture d'écran 2023-12-26 144000.png

aj1973
Community Champion
Community Champion

Actually it is not possible : 

According to the Microsoft Fabric Community, it is currently not possible to use data sources from different gateways in a single dataset. However, there are some workarounds that you can try. For example, you can create separate datasets for each gateway and then merge them in a single report. Alternatively, you can use Power Query to combine data from different sources into a single table.

You can add your idea :

Microsoft Idea

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

in my case it is not a single dataset, they are 2 differents reports (one in each server, in each production site)
i published the reports from the different sources, but when i go in power bi service to schedule the refresh for the dataset 2, i found it's connected to the gateway of the dataset 1
like in this image
Capture d'écran 2023-12-26 1507271.jpg

aj1973
Community Champion
Community Champion

Yes I see your issue, It's a personnal Gateway and Power BI service(Logged in with your user name) can only accpet one Personal Gateway at a time. And a personal Gateway can only be used by its owner.

Can you install a Standard Gateway on the Server n 2?

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

good morning
it works perfectly, thank you my friend @aj1973 

another thing, if you permit, now if i want to merge the two reports in only one and make a switch button to choose the production site, is it possible?
(the two datasets are the same, just the location change)

thank you so much

aj1973
Community Champion
Community Champion

From your desktop connect to both datasets

aj1973_0-1703686376768.png

 

And build a new report from the combined datasets. Create a page for each Dataset/Report and add a Bookmark(Optional) to navigate between the 2 pages .

 

Just wondering out of the box, do you know about Dataflows? because in your scenario it would have been better if you used One Dataflow to upload data from both servers and then use it for your report. Hence you have only one schedule refresh which is the Dataflow.

 

Anyway, it was just an idea. You are Welcome Sofiene 😉 

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

thank you my friend, at first i'll try the bookmarks, and then i'll learn more about dataflows.

thanks again, you helped me alot

ahh ok, thank you, i'll download the standard one, and try it.

aj1973
Community Champion
Community Champion

The picture from Microsoft shows 2 different Gateways , Standard and Personal Gateway installed on the same server but only one can work.

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.