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 stand-alone from eachother but when I change credentials in one file then when I open the other file the credentials are automatically changed there as well. How to create a unique source allthough it is same server and database?
The two different users access different data from the database. That is why I need different credentials.
Thanks!
/Kris
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
7 Replies
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