{"id":33679,"date":"2021-01-22T12:12:11","date_gmt":"2021-01-22T12:12:11","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=33679"},"modified":"2021-01-22T12:12:12","modified_gmt":"2021-01-22T12:12:12","slug":"row-level-security-rls-for-power-bi-desktop","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/row-level-security-rls-for-power-bi-desktop\/","title":{"rendered":"Row-Level Security (RLS) for Power BI Desktop"},"content":{"rendered":"\n<p>We can use row-level security (RLS) with Power BI Desktop to restrict data access for specified users. However, filters restrict data at the row level. Also, we can define filters within roles. Some of the features of row-level security (RLS) are &#8211;<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Firstly, you can now configure RLS for data models imported into Power BI with Power BI Desktop. <\/li><li>Secondly, you can also configure RLS on datasets that are using\u00a0DirectQuery, like SQL Server. <\/li><li>Also, for Analysis Services live connections, you configure Row-level security on the on-premises model. However, the security option doesn&#8217;t show up for live connection datasets.<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Steps to define roles and rules in Power BI Desktop<\/strong><\/h4>\n\n\n\n<p>We may define roles and rules within Power BI Desktop using the following steps &#8211; <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Firstly, import data into your Power BI Desktop report, or configure a DirectQuery connection.<\/li><li>Secondly, from the\u00a0<strong>Modeling<\/strong>\u00a0tab, select\u00a0<strong>Manage Roles<\/strong>.<\/li><li>Thirdly, from the\u00a0<strong>Manage roles<\/strong>\u00a0window, select\u00a0<strong>Create<\/strong>.<\/li><li>Next, under\u00a0<strong>Roles<\/strong>, provide a name for the role.<\/li><li>Further, under\u00a0<strong>Tables<\/strong>, select the table to which you want to apply a DAX rule.<\/li><li>Then, in the\u00a0<strong>Table filter DAX expression<\/strong>\u00a0box, enter the DAX expressions. This expression returns a value of true or false.\u00a0<\/li><li>Once you have created the DAX expression, select the checkmark above the expression box to validate the expression.<\/li><li>Lastly, select\u00a0<strong>Save<\/strong>.<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"validate-the-roles-within-power-bi-desktop\"><strong>Steps to validate the roles within Power BI Desktop<\/strong><\/h4>\n\n\n\n<p>Once you have created your roles, test the results of the roles within Power BI Desktop<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Firstly, from the Modeling tab, select View as Roles.<\/li><li>Secondly, the View as roles window appears, where you see the roles you&#8217;ve created.<\/li><li>Then, select a role you created, and then select OK to apply that role.<\/li><li>The report renders the data relevant for that role.<\/li><li>Now, you can also select Other user and supply a given user.<\/li><li>Lastly, select OK.<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"limitations\"><strong>Row-Level Security Limitations<\/strong><\/h4>\n\n\n\n<p>Some of the limitations for row-level security on cloud models are &#8211;<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Firstly, in case you previously defined roles and rules in the Power BI service, then you must re-create them in Power BI Desktop.<\/li><li>Secondly, you can define RLS only on the datasets created with Power BI Desktop. If you want to enable RLS for datasets created with Excel, you must convert your files into Power BI Desktop (PBIX) files first.\u00a0<\/li><li>Lastly, only Import and DirectQuery connections are supported. Further, live connections to Analysis Services are managed in the on-premises model.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter\"><a href=\"https:\/\/www.testpreptraining.ai\/analyzing-data-with-microsoft-power-bi-da-100-free-test\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Microsoft-Exam-DA-100-Free-Practice-Test.png\" alt=\"Microsoft Exam DA-100 Free Practice Test\"\/><\/a><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"<p>We can use row-level security (RLS) with Power BI Desktop to restrict data access for specified users. However, filters restrict data at the row level. Also, we can define filters within roles. Some of the features of row-level security (RLS) are &#8211; Firstly, you can now configure RLS for data models imported into Power BI&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[174],"tags":[1830,4169,3954],"class_list":["post-33679","page","type-page","status-publish","hentry","category-microsoft-azure","tag-da-100-study-guide","tag-https-www-testpreptraining-com-analyzing-data-with-microsoft-power-bi-da-100-free-testrow-level-security-rls","tag-microsoft-exam-da-100-free-practice-test"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Row-Level Security (RLS) for Power BI Desktop | Testprep Training<\/title>\n<meta name=\"description\" content=\"Boost your chances to qualify Microsoft Exam DA-100 with latest practice test. Learn about Row-Level Security (RLS) for Power BI Desktop!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.testpreptraining.ai\/tutorial\/row-level-security-rls-for-power-bi-desktop\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Row-Level Security (RLS) for Power BI Desktop | Testprep Training\" \/>\n<meta property=\"og:description\" content=\"Boost your chances to qualify Microsoft Exam DA-100 with latest practice test. Learn about Row-Level Security (RLS) for Power BI Desktop!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/row-level-security-rls-for-power-bi-desktop\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2021-01-22T12:12:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Microsoft-Exam-DA-100-Free-Practice-Test.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/row-level-security-rls-for-power-bi-desktop\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/row-level-security-rls-for-power-bi-desktop\/\",\"name\":\"Row-Level Security (RLS) for Power BI Desktop | Testprep Training\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2021-01-22T12:12:11+00:00\",\"dateModified\":\"2021-01-22T12:12:12+00:00\",\"description\":\"Boost your chances to qualify Microsoft Exam DA-100 with latest practice test. Learn about Row-Level Security (RLS) for Power BI Desktop!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/row-level-security-rls-for-power-bi-desktop\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/row-level-security-rls-for-power-bi-desktop\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/row-level-security-rls-for-power-bi-desktop\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Row-Level Security (RLS) for Power BI Desktop\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"name\":\"Testprep Training Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\",\"name\":\"Testprep Training\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"contentUrl\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"width\":583,\"height\":153,\"caption\":\"Testprep Training\"},\"image\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Row-Level Security (RLS) for Power BI Desktop | Testprep Training","description":"Boost your chances to qualify Microsoft Exam DA-100 with latest practice test. Learn about Row-Level Security (RLS) for Power BI Desktop!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.testpreptraining.ai\/tutorial\/row-level-security-rls-for-power-bi-desktop\/","og_locale":"en_US","og_type":"article","og_title":"Row-Level Security (RLS) for Power BI Desktop | Testprep Training","og_description":"Boost your chances to qualify Microsoft Exam DA-100 with latest practice test. Learn about Row-Level Security (RLS) for Power BI Desktop!","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/row-level-security-rls-for-power-bi-desktop\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2021-01-22T12:12:12+00:00","og_image":[{"url":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Microsoft-Exam-DA-100-Free-Practice-Test.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/row-level-security-rls-for-power-bi-desktop\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/row-level-security-rls-for-power-bi-desktop\/","name":"Row-Level Security (RLS) for Power BI Desktop | Testprep Training","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2021-01-22T12:12:11+00:00","dateModified":"2021-01-22T12:12:12+00:00","description":"Boost your chances to qualify Microsoft Exam DA-100 with latest practice test. Learn about Row-Level Security (RLS) for Power BI Desktop!","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/row-level-security-rls-for-power-bi-desktop\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/row-level-security-rls-for-power-bi-desktop\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/row-level-security-rls-for-power-bi-desktop\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Row-Level Security (RLS) for Power BI Desktop"}]},{"@type":"WebSite","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","name":"Testprep Training Tutorials","description":"","publisher":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization","name":"Testprep Training","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","contentUrl":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","width":583,"height":153,"caption":"Testprep Training"},"image":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/33679","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/comments?post=33679"}],"version-history":[{"count":2,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/33679\/revisions"}],"predecessor-version":[{"id":33695,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/33679\/revisions\/33695"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=33679"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=33679"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=33679"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}