Forum Discussion
Separate credentials for each workspace - Security issue
Hi SEACHAD ,
Please configure Row-level security (RLS) in Power BI Desktop to have a try and then republish to Service.
The report is using the same credential and that they viewed is the same one. For this situation, it is a best solution to try RLS. It can be used to restrict data access for given users. You could use the username() or userprincipalname() DAX function to implement dynamically.
Please reference:
Row-level security (RLS) with Power BI
Power BI Row-Level Security And Where To Filter
Can you use GROUPS with Power BI Row-Level Security (RLS)???
- SEACHAD6 years agoHelper I
Thank very much for your answer, but this solution will no solve my problem.
Surely I have not explained my problem well.
I have created a report on powerbi desktop that, among other data sources, connects to the Microsoft management API and also uses the Azure cost connector.
I have created two diferent workspaces, Company A and Company B and I have uploaded the report to the Power BI service
In each of the workspaces. I have configured the credentials for the management API data source with a different user corresponding to each company (workspace company A -> [email protected] and for the workspace of company B -> user @ companyB.com) as well as the tenant (parameter) and the user corresponding to each one in the cost connector data source.
I have created an application for each of them.
The objective is to see in each application only the information corresponding to each of the companies.
Now when I update the datasets in the company A application I see the cost data of company A (cost connector) and, for example the user data (API management) of company A, perfect.
But in the application of company B I see the cost data of company B but the azure users data of company A?
How is this possible if I have configured the access credentials of a user from a different company in that data source?
Thank you
Luis
- ManuelaOsorio4 years agoRegular Visitor
Hi Seachad, Could you solve this? I have the same error and I don't know how to solve it
- SEACHAD4 years agoHelper I
Hello Manuela
Finally I changed the aproach and I access to the APIs with and external aplication developed in python and its otputs are loaded into powerbi