Forum Discussion
Couldn't load the data for this visual
I am using a security level for a table in power BI.
Will it works.?-----Yes Lakshmi this would work and is supported but the solution needs to done right.
When I apply Row level filters, none of the teammates can see the visuals.
When I delete the rew levvel filters, all the members can see the data.
I want to restrict a column from a tabel to be seen by everyone, how can I do that?
- Conarl_on_BI8 years ago
Helper III
Create a group for the row you're restricting your members on, based on the table then assign these users to the row you have created. Example in Power BI desktop under the Modeling Tab---> click on Manage Roles and add the row level security and the members here. Note once you have define the rows you can test these roles by click View as Role tosee what each member or group would see once in that role.
Thanks,
Conarl_On_BI
- lakshmi92288 years ago
Helper III
I have done that previously.
When I do that, none of the can see the visuals.They are getting some error like the below picture.
- Conarl_on_BI8 years ago
Helper III
Create a group for the row you're restricting your members on, based on the table then assign these users to the row you have created. Example in Power BI desktop under the Modeling Tab---> click on Manage Roles and add the row level security and the members here. Note once you have define the rows you can test these roles by click View as Role tosee what each member or group would see once in that role.
If you intent is to use a security bridge table to manage the row level security then follow the instructs from Paul in the link below.
https://www.youtube.com/watch?v=GpinnvFTdVUThanks,
Conarl_On_BI
- lakshmi92288 years ago
Helper III
When I delete the row level security filter, they can see that.
Is there any other way to restrict a column.
For example, a table has all the details of a customer, few managers shouldnt see the email address column of a table.
Is there a way to restrict the data like that.
Please let me knowThanks,
Lakshmi
- Conarl_on_BI8 years ago
Helper III
Again yes this can be done. You can explore a DAX to get this working. Please watch Paul video he provides an approach to getting this working.