Forum Discussion
connect two different users on same azure database on the same server different pbix files
Anonymous,
For same server name and same database name, Power BI Desktop only store a credential in Date source settings->global permissions, this is the reason why credentials are automatically changed there as well when you open other PBIX file.
In your scenario, I would recommend you create a single Power BI report using an admin account, and then define Row Level Security in your dataset.
Regards,
Lydia
Anonymous
Is it possible to give a alias to the server or the db som that they can be separated by alias? Is that what you mean?
If that is possible, how do I do that?
Thanks!
/Kris
Anonymous,
Yes. You can set alias for the Azure SQL database, then it is possible to provide different server name in the two PBIX file.
Regards,
Lydia
Anonymous
Thank you!
But then I assume that it is not possible to set alias on the server or DB in Power BI Desktop?
That would then be the solution since I then can have 2 servers in the list with 2 different log in credentials.
/Kris
Anonymous,
In Power BI Desktop, it is not possible to set alias for server or database. You would need to use Powershell as described in the above blog.
Regards,
Lydia