Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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's avatar
    Anonymous
    8 years ago

    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's avatar
Anonymous
Not applicable
8 years ago

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