Same database server with different SA

[Anonymous]

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

[v-ljerr-msft]

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

[Anonymous · Accepted solution]

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