Forum Discussion
Helper IIICouldn't load the data for this visual
Helper IIIYes, SO is that a problem?
It is if you don't belong to a Role. Make sure you're in a role by visiting the security options in the uploaded dataset.
- lakshmi9228
I am sorry, I couldn't understand you.
I want to create a security role.
Now, I deleted the role and it is working fine.
But I need to add a security role to complete my task.
Please let me know how can I do that which will be much helpful for me.Thanks,
Lakshmi
You'll need to create the role and assign people to that role. Those people will have the DAX expression you defined in Power BI Desktop applied to their data, filtering it down based on your RLS DAX expressions.
Example:
1. In Power BI Desktop, create the "US Sales" role. You'll probably set a statement that looks something like: [Country] = "United States".
2. Upload to the Power BI Service
3. Using the Security options on the dataset, assign your US salespersons to that role. They'll now only see US data.
Anyone who doesn't have a role assigned at that point will get 401s.
Here's the documentation with a step-by-step:
https://docs.microsoft.com/en-us/power-bi/service-admin-rls
- lakshmi9228
So, This is what I am doing.
I am using a security level for a table in power BI.
Will it works.?What I am doing is, a data from a particular table should be seen by only few people.
So, I am using the table in Row level security.
The rest all the persons should see the other reports which came from the other tables which are joined.Thanks,
Lakshmi