WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Learn Power BI » Power BI Security

Power BI Security

By Jeevan A YJeevan A Y | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

Security in Power BI

Data Security is the most important aspect when we share the data with others, they could be external clients or internal stakeholders. Often times we don’t want to share all the data with everybody. For example when we are sharing the file with regional managers what is the point of sharing other region’s sales data to the “South zone manager. So with this regard, we can create security access in Power BI while sharing the report.

In this article, we will take you through the process of building row-level security access in Power BI.

Power-BI-Security

Row Level Security

Data is stored in rows and columns, so when we want to share the data with a larger group all of them don’t want to see all the rows of data. So we can create “row-level security” in power bi to enable the specific person to see an only specific set of data.

For example, a sales manager of “India” has to see only the data of “India” region sales numbers, and the overall business head can see all the region’s data. So this is the kind of security that we need to create before sharing the data, and this is called “Row Level Security.”

Create Row Level Security in Power BI

To create row-level security, we need to have some sort of data, and we have already created a simple chart in Power BI.

You can download the workbook to use the same file as we used in this example.

You can download this Security in Power BI Excel Template here – Security in Power BI Excel Template

Below is the chart created in Power BI to show the product-wise sales chart.

Power BI Security - Bar Chart

At this moment, we have overall all the countries’ sales based on different products. Now we need to create row-level security to show only specific country sales based on products, and below are the countries we have on this list.

Canada, France, Germany, Mexico, and the United States of America.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Follow the below steps.

Step 1: Under the MODELLING tab, click on “Manage Roles.”

Power BI Security - Manage Rules

Step 2: This will open up the “Manage Roles” window like the below one.

Power BI Security - Manage Role Window

Step 3: Click on the “Create” option to create the first country role.

Power BI Security - Create Role

Step 4: Give a name to this role. Since we are creating first country security, give the names as “Canada.”

Power BI Security - Create Role Name

Step 5: Next, we have the table name as “Data Table” click on the ellipsis (three dots) it will show the “Add Filters” option.

Power BI Security - Add Filter

Step 6: Hover on “Add Filter” it will open up all the columns in the table. Since we are applying country-wise row-level security, choose the option of the “Country” column.

Power BI Security - Add Filter (Country)

Step 7:  Using the “DAX” expression, we need to create a role here. Enter the country name in double-quotes. Click on “Save” to close the “Manage Roles” window.

Table Filter (Dax Expression)

Step 8:  Now, we have created row-level security for the country “Canada.”

Under the MODELING tab next to the option of “Manage Roles,” we have an option called “View as Roles” click on this.

View Roles

This will open up the roles list that we have created. Choose the role “Canada” and click on “Ok.”

Select Role as Canada

Now we can see only the “Canada” country sales chart only.

Power BI Security - Canada Report

As you can see at the top of the chart, it shows “now viewing the report as Canada” to go back to the older chart, we can click on the “Stop Viewing” option.

Like this creates roles for other countries as well.

Now in Power BI services, we need to assign the email id’s to share the report.

Configure Power BI Services

  • Publish the report to Power BI Services by clicking on the “Publish” option in Power BI Desktop.

Publish Option

  • Now log in to the Power BI Services account in the Power BI services account, it will be published in My Workspace.

Power BI Security - My Workspace

  • Click on three dots in front of the published article under Dataset.

Power BI Security - Configure

  • Choose the “Security” option.

Select Security Option

  • It will show a row-level security option for you. Enter the email address of the respective sales manager here and click on the “Add” option.

Row Level Security

Now save it. Like this, we can create row-level security in Power BI.

Note: Power BI dashboard file can also be downloaded from the link below, and the final output can be viewed.

You can download this Power BI Security Template here – Power BI Security Template

Things to Remember

  • Once the Row Level Security is created in Desktop, you need to publish the report to Power BI Services, and you need to have a paid version to share the report with the concerned person.
  • Only filtered data can be viewed from the concerned person.

Recommended Articles

This has been a guide to Power BI Security. Here we discuss how to build row-level security access while sharing power bi reports using an example. You can learn more from the following articles –

  • RELATED Function in Power BI
  • Power BI IF Statement
  • Power BI vs QlikView
  • Power BI vs Excel
  • Power BI Calculate
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Download Power BI Security Template

By continuing above step, you agree to our Terms of Use and Privacy Policy.

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Security in Power BI Excel Template

Special Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More