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,
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
Hi Lydia,
I'm only fetching this data from HQ and they only give us access with two user accounts for the different divisions. Does this mean that this is not possible to solve in Power BI Desktop or does a workaround exist?
Thanks!
/Kris
Anonymous,
The workaround that i can think of is to use different server name or different database name in the two PBIX file.
Regards,
LydiaAnonymous
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