How to add Row level security?

0 votes
How to add Row level security?
Oct 30, 2019 in Power BI by anonymous
• 3,380 points
54 views

1 answer to this question.

0 votes

To add Row Level Security, Follow the below steps:

1. Go to the Modelling ribbon and click on Manage Roles.

2. You will see a dialog box to add Roles and manage roles.

3. Click on Create and enter the details, and optional DAX expression to filter the required data.

4. Click on Save.

5. To change roles, click on View as Roles in the same ribbon.

6. This will filter data as required.

7. Now assign these roles to users to maintain security.

8. Publish the report and go to Power BI Service

9. Go to the datasets. Click on ... and select security.

10. Now select Role created and enter the mail id of users for that role. Add users to roles.

11. Click save and you are ready to go.

This will allow you to now view reports accordingly to the role.

answered Oct 30, 2019 by ch
• 3,380 points

Related Questions In Power BI

0 votes
1 answer

use Power BI's Row Level security to implement employee filter

We also have a similar feature in ...READ MORE

answered Oct 22, 2018 in Power BI by Hannah
• 18,040 points
180 views
0 votes
1 answer

How to add an image to power bi report – power bi web

There are visuals (e.g. table) that can ...READ MORE

answered Sep 27, 2018 in Power BI by Kalgi
• 51,850 points
165 views
0 votes
1 answer

Row Level Security not applied through LOOKUPVALUE in Default filter

I see what you mean now. LOOKUPVALUE appears to ...READ MORE

answered Nov 8, 2018 in Power BI by Upasana
• 8,590 points
1,727 views
0 votes
1 answer

How to add slicer from a different tables?

Hi, Join is normally performed to get ...READ MORE

answered Mar 1, 2019 in Power BI by Cherukuri
• 32,460 points
1,305 views
0 votes
1 answer

Displaying Table Schema using Power BI with Azure IoT Hub

Answering your first question, Event Hubs are ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by nirvana
• 3,060 points
173 views
+1 vote
1 answer

Unable to install connector for Power Bi and PostgreSQL

I think the problem is not at ...READ MORE

answered Aug 21, 2018 in Power BI by nirvana
• 3,060 points
1,073 views
+2 votes
2 answers

Migrate power bi collection to power bi embedded

I agree with Kalgi, this method is ...READ MORE

answered Oct 11, 2018 in Power BI by Hannah
• 18,040 points
239 views
+1 vote
1 answer

Connect power bi desktop to dataset and create custom reports

Yes using Power BI REST API to ...READ MORE

answered Sep 18, 2018 in Power BI by Kalgi
• 51,850 points
236 views
0 votes
1 answer

How to add roles in power BI?

1. Go to Modelling ribbon -> Manage ...READ MORE

answered Oct 30, 2019 in Power BI by ch
• 3,380 points
91 views
0 votes
1 answer

How to show visualization (map) based on latitude and longitude points in power BI?

Follow the below steps: 1. Select the map ...READ MORE

answered Oct 17, 2019 in Power BI by anonymous
• 3,380 points
205 views