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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
knvsiddarth
Regular Visitor

How can we connect to data bases in different Servers dynamically based on the selection

Hi when you have two companies A & B where the data achitecture is as below .

 

Company A 

DatabaseName: dataA

Server: ServerA

 

Compnay B

DatabaseName: dataB

Server: ServerB

 

is there a way to paramertize selection of data source based on the selection of the company so that we can access the serverB when company B is selected .

 

In this case the database is SQL Server 2014 and both Databases contain exactly same database objects .

 

2 ACCEPTED SOLUTIONS
Greg_Deckler
Super User
Super User

Yes, you would use Query Parameters to do this.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

Anonymous
Not applicable

Hi @knvsiddarth,

 

I have written a blog Post about templating in a multitenant environment.

in there you can find some useful things about setting parameters, updating datasources and credentials.

 

Hope it helps.

 

Thanos

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi @knvsiddarth,

 

I have written a blog Post about templating in a multitenant environment.

in there you can find some useful things about setting parameters, updating datasources and credentials.

 

Hope it helps.

 

Thanos

Greg_Deckler
Super User
Super User

Yes, you would use Query Parameters to do this.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.