Forum Discussion
connect two different users on same azure database on the same server different pbix files
Hi, I have a challenge. I have 2 pbix files. They are both connected to same Azure SQL server and same database. BUT it is 2 different users in these 2 files. I thought the 2 files where ...
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