Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Abevann
Helper III
Helper III

Two or more databases in same server handled with on-premises data gateway

‎02-11-2022 12:45 PM

Guys,

I'm having a request; in one server I have multiple SQL databases from different companies and I'm wondering the best way to update the information on the dashboard. Is it possible to install several instances of the on-premises data gateway in order to update the data of all databases in the dashboards?

 

Thanks, regards,

Abelardo

Labels:
Message 1 of 4
645 Views
0
1 ACCEPTED SOLUTION
aj1973
Community Champion
Community Champion

‎02-11-2022 02:41 PM

Hi @Abevann 

Only one instance of On-premesis Gateway can be intalled on the server. You can cluster all your SQL DB on that Gateway once installed. 

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

Message 2 of 4
583 Views
0
3 REPLIES 3
aj1973
Community Champion
Community Champion

‎02-11-2022 02:41 PM

Hi @Abevann 

Only one instance of On-premesis Gateway can be intalled on the server. You can cluster all your SQL DB on that Gateway once installed. 

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

Message 2 of 4
584 Views
0
Abevann
Helper III
Helper III
In response to aj1973

‎02-14-2022 08:10 AM

Hello Amine, 

 

Ok, I'll cluster both DB in on-premises and go back to comment the results.

 

Thanks, regards,

Abelardo

Message 3 of 4
524 Views
0
Abevann
Helper III
Helper III
In response to Abevann

‎02-16-2022 08:51 AM

Today I checked the automatic data update, and it is working with no problems.

 

Thanks, regards,

Abelardo

Message 4 of 4
502 Views

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!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

View All