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
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
Solved! Go to Solution.
We had an work around, created alias for the server and it works fine 🙂 (Canme foe each client)
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
We had an work around, created alias for the server and it works fine 🙂 (Canme foe each client)
User | Count |
---|---|
17 | |
2 | |
2 | |
2 | |
1 |
User | Count |
---|---|
20 | |
10 | |
5 | |
4 | |
3 |