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
Anonymous
Not applicable

Same database server with different SA

Hi Guys,

 

We are trying to connect one DB server with mutiple service accounts 

DB Server: XYZ

DB Name:Xyz

DB Windows Account: team.read

 

DB Server: XYZ

DB Name:Xyz

DB Windows Account: client1.read

 

Got below error:DMTS_DuplicateDatasourceError

 

And moreover it does not allow mutiple gateways on single server; dont expect us to create gateway in 10 server for 10 clients.

 

Any thoughts!

 

Regards,

Navin

1 ACCEPTED SOLUTION
Anonymous
Not applicable

We had an  work around, created alias for the server and it works fine 🙂 (Canme foe each client)

View solution in original post

2 REPLIES 2
v-ljerr-msft
Employee
Employee

Hi @Anonymous,

 

It is a known limitation in Power BI currently. Here is the idea shared on Power BI Idea forum. You can vote it up and add your comments there to improve Power BI on this feature. Smiley Happy 

 

Regards

Anonymous
Not applicable

We had an  work around, created alias for the server and it works fine 🙂 (Canme foe each client)

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.