topic Re: Same database server with different SA in Developer

Same database server with different SA

Anonymous — Fri, 12 Jan 2018 18:24:49 GMT

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

Re: Same database server with different SA

v-ljerr-msft — Mon, 15 Jan 2018 07:04:33 GMT

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.

Regards

Re: Same database server with different SA

Anonymous — Wed, 10 Jul 2019 15:44:17 GMT

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