{"id":963,"date":"2023-04-18T16:22:56","date_gmt":"2023-04-18T19:22:56","guid":{"rendered":"https:\/\/antunes.digital\/?p=963"},"modified":"2024-02-23T09:28:39","modified_gmt":"2024-02-23T12:28:39","slug":"rls-seguranca-em-nivel-de-linha","status":"publish","type":"post","link":"https:\/\/antunes.digital\/fabio\/2023\/04\/18\/rls-seguranca-em-nivel-de-linha\/","title":{"rendered":"RLS &#8211; Seguran\u00e7a em n\u00edvel de linha"},"content":{"rendered":"\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"RLS - Seguran\u00e7a em n\u00edvel de Linha - Dicas Preciosas | Power Bi\" width=\"525\" height=\"295\" src=\"https:\/\/www.youtube.com\/embed\/zp-zF0b7_X0?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<h1 class=\"wp-block-heading\"><a>Introdu\u00e7\u00e3o<\/a><\/h1>\n\n\n\n<p class=\"wp-block-paragraph\"><em>O RLS (Row Level Security) \u00e9 uma ferramenta do Power BI que permite limitar o acesso de usu\u00e1rios a determinados dados em um relat\u00f3rio, de acordo com sua fun\u00e7\u00e3o ou n\u00edvel de permiss\u00e3o. O RLS \u00e9 uma forma eficiente de garantir a seguran\u00e7a dos dados e evitar o acesso n\u00e3o autorizado a informa\u00e7\u00f5es confidenciais. Neste curso, voc\u00ea aprender\u00e1 como configurar o RLS para proteger seus dados e garantir que apenas as pessoas autorizadas possam acess\u00e1-los<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Row Level Security (RLS) is a feature in Power BI that allows you to restrict user access to specific data in a report based on their role or permission level. RLS is an effective way to ensure data security and prevent unauthorized access to confidential information. In this course, you will learn how to configure RLS to protect your data and ensure that only authorized individuals can access it.<em><\/em><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><a>Cen\u00e1rio<\/a><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;Tr\u00eas usu\u00e1rios dever\u00e3o acessar coisas diferentes no Power bi, ou seja, quero que pessoas espec\u00edficas tenham acesso a dados espec\u00edficos, vamos entender melhor.<\/p>\n\n\n\n<h1 class=\"wp-block-heading\"><a>Configurar o RLS no Power bi Desktop<\/a><\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Primeiro vamos definir os usu\u00e1rios e categoria. Nesse caso como eu queria dar liberdade para a \u00e1rea de neg\u00f3cio definir \u201cquem acessa o que\u201d preferi fazer uma tabela em Excel, mas tem op\u00e7\u00e3o de criar um formul\u00e1rio no Power apps ou lista no sharepoint, aqui no nosso caso vamos de Excel.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">User1 &#8211; Adele &#8211; <a href=\"mailto:AdeleV@mj6g.onmicrosoft.com\">AdeleV@mj6g.onmicrosoft.com<\/a> acessa somente dados do Power Apps<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">User2 &#8211; Grady &#8211; <a href=\"mailto:GradyA@mj6g.onmicrosoft.com\">GradyA@mj6g.onmicrosoft.com<\/a>&nbsp;&nbsp; acessa somente dados do Power bi<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">User3 \u2013 Fabio &#8211; <a href=\"mailto:fabio@mj6g.onmicrosoft.com\">fabio@mj6g.onmicrosoft.com<\/a> &nbsp;&nbsp;acessa somente dados do Power Automate e Sharepoint&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"455\" src=\"https:\/\/antunes.digital\/wp-content\/uploads\/2023\/04\/image-1024x455.png\" alt=\"\" class=\"wp-image-964\" srcset=\"https:\/\/antunes.digital\/fabio\/wp-content\/uploads\/2023\/04\/image-1024x455.png 1024w, https:\/\/antunes.digital\/fabio\/wp-content\/uploads\/2023\/04\/image-300x133.png 300w, https:\/\/antunes.digital\/fabio\/wp-content\/uploads\/2023\/04\/image-768x341.png 768w, https:\/\/antunes.digital\/fabio\/wp-content\/uploads\/2023\/04\/image.png 1036w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Trazendo para o Power bi vamos relacionar com a nossa Tabela Fato.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"652\" height=\"434\" src=\"https:\/\/antunes.digital\/wp-content\/uploads\/2023\/04\/image-1.png\" alt=\"\" class=\"wp-image-965\" srcset=\"https:\/\/antunes.digital\/fabio\/wp-content\/uploads\/2023\/04\/image-1.png 652w, https:\/\/antunes.digital\/fabio\/wp-content\/uploads\/2023\/04\/image-1-300x200.png 300w\" sizes=\"(max-width: 652px) 100vw, 652px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Vamos criar uma medida apenas para visualizar melhor, mas n\u00e3o \u00e9 mandat\u00f3rio.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"450\" height=\"136\" src=\"https:\/\/antunes.digital\/wp-content\/uploads\/2023\/04\/image-2.png\" alt=\"\" class=\"wp-image-966\" srcset=\"https:\/\/antunes.digital\/fabio\/wp-content\/uploads\/2023\/04\/image-2.png 450w, https:\/\/antunes.digital\/fabio\/wp-content\/uploads\/2023\/04\/image-2-300x91.png 300w\" sizes=\"(max-width: 450px) 100vw, 450px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Agora vamos configurar isso no menu Modelagem\/Gerenciar Fun\u00e7\u00f5es\/Criar<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"883\" height=\"468\" src=\"https:\/\/antunes.digital\/wp-content\/uploads\/2023\/04\/image-3.png\" alt=\"\" class=\"wp-image-967\" srcset=\"https:\/\/antunes.digital\/fabio\/wp-content\/uploads\/2023\/04\/image-3.png 883w, https:\/\/antunes.digital\/fabio\/wp-content\/uploads\/2023\/04\/image-3-300x159.png 300w, https:\/\/antunes.digital\/fabio\/wp-content\/uploads\/2023\/04\/image-3-768x407.png 768w\" sizes=\"(max-width: 883px) 100vw, 883px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"884\" height=\"529\" src=\"https:\/\/antunes.digital\/wp-content\/uploads\/2023\/04\/image-4.png\" alt=\"\" class=\"wp-image-968\" srcset=\"https:\/\/antunes.digital\/fabio\/wp-content\/uploads\/2023\/04\/image-4.png 884w, https:\/\/antunes.digital\/fabio\/wp-content\/uploads\/2023\/04\/image-4-300x180.png 300w, https:\/\/antunes.digital\/fabio\/wp-content\/uploads\/2023\/04\/image-4-768x460.png 768w\" sizes=\"(max-width: 884px) 100vw, 884px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Alterar &#8220;Valor&#8221; para a medida criada (pode criar a fun\u00e7\u00e3o aqui, se n\u00e3o foi criada na medida)<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"886\" height=\"526\" src=\"https:\/\/antunes.digital\/wp-content\/uploads\/2023\/04\/image-5.png\" alt=\"\" class=\"wp-image-969\" srcset=\"https:\/\/antunes.digital\/fabio\/wp-content\/uploads\/2023\/04\/image-5.png 886w, https:\/\/antunes.digital\/fabio\/wp-content\/uploads\/2023\/04\/image-5-300x178.png 300w, https:\/\/antunes.digital\/fabio\/wp-content\/uploads\/2023\/04\/image-5-768x456.png 768w\" sizes=\"(max-width: 886px) 100vw, 886px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Voc\u00ea pode testar a funcionalidade clicando em modelagem\/Exibir como.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"320\" height=\"319\" src=\"https:\/\/antunes.digital\/wp-content\/uploads\/2023\/04\/image-6.png\" alt=\"\" class=\"wp-image-970\" srcset=\"https:\/\/antunes.digital\/fabio\/wp-content\/uploads\/2023\/04\/image-6.png 320w, https:\/\/antunes.digital\/fabio\/wp-content\/uploads\/2023\/04\/image-6-300x300.png 300w, https:\/\/antunes.digital\/fabio\/wp-content\/uploads\/2023\/04\/image-6-150x150.png 150w\" sizes=\"(max-width: 320px) 100vw, 320px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"886\" height=\"334\" src=\"https:\/\/antunes.digital\/wp-content\/uploads\/2023\/04\/image-7.png\" alt=\"\" class=\"wp-image-971\" srcset=\"https:\/\/antunes.digital\/fabio\/wp-content\/uploads\/2023\/04\/image-7.png 886w, https:\/\/antunes.digital\/fabio\/wp-content\/uploads\/2023\/04\/image-7-300x113.png 300w, https:\/\/antunes.digital\/fabio\/wp-content\/uploads\/2023\/04\/image-7-768x290.png 768w\" sizes=\"(max-width: 886px) 100vw, 886px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Publique o relat\u00f3rio.<\/p>\n\n\n\n<h1 class=\"wp-block-heading\"><a>Configurando RLS no Power bi Servi\u00e7o<\/a><\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">No Workspace v\u00e1 nas op\u00e7\u00f5es do conjunto de dados e selecione seguran\u00e7a.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"563\" height=\"525\" src=\"https:\/\/antunes.digital\/wp-content\/uploads\/2023\/04\/image-8.png\" alt=\"\" class=\"wp-image-972\" srcset=\"https:\/\/antunes.digital\/fabio\/wp-content\/uploads\/2023\/04\/image-8.png 563w, https:\/\/antunes.digital\/fabio\/wp-content\/uploads\/2023\/04\/image-8-300x280.png 300w\" sizes=\"(max-width: 563px) 100vw, 563px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Vou adicionar somente 2 para testarmos.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"557\" height=\"299\" src=\"https:\/\/antunes.digital\/wp-content\/uploads\/2023\/04\/image-9.png\" alt=\"\" class=\"wp-image-973\" srcset=\"https:\/\/antunes.digital\/fabio\/wp-content\/uploads\/2023\/04\/image-9.png 557w, https:\/\/antunes.digital\/fabio\/wp-content\/uploads\/2023\/04\/image-9-300x161.png 300w\" sizes=\"(max-width: 557px) 100vw, 557px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u00c9 poss\u00edvel testar online tamb\u00e9m, em Testar como fun\u00e7\u00e3o.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"468\" height=\"244\" src=\"https:\/\/antunes.digital\/wp-content\/uploads\/2023\/04\/image-10.png\" alt=\"\" class=\"wp-image-974\" srcset=\"https:\/\/antunes.digital\/fabio\/wp-content\/uploads\/2023\/04\/image-10.png 468w, https:\/\/antunes.digital\/fabio\/wp-content\/uploads\/2023\/04\/image-10-300x156.png 300w\" sizes=\"(max-width: 468px) 100vw, 468px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Veja o que acontece se eu tento acessar com um usu\u00e1rio n\u00e3o autorizado.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"741\" height=\"360\" src=\"https:\/\/antunes.digital\/wp-content\/uploads\/2023\/04\/image-11.png\" alt=\"\" class=\"wp-image-975\" srcset=\"https:\/\/antunes.digital\/fabio\/wp-content\/uploads\/2023\/04\/image-11.png 741w, https:\/\/antunes.digital\/fabio\/wp-content\/uploads\/2023\/04\/image-11-300x146.png 300w\" sizes=\"(max-width: 741px) 100vw, 741px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Agora com o user3<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"886\" height=\"549\" src=\"https:\/\/antunes.digital\/wp-content\/uploads\/2023\/04\/image-12.png\" alt=\"\" class=\"wp-image-976\" srcset=\"https:\/\/antunes.digital\/fabio\/wp-content\/uploads\/2023\/04\/image-12.png 886w, https:\/\/antunes.digital\/fabio\/wp-content\/uploads\/2023\/04\/image-12-300x186.png 300w, https:\/\/antunes.digital\/fabio\/wp-content\/uploads\/2023\/04\/image-12-768x476.png 768w\" sizes=\"(max-width: 886px) 100vw, 886px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Seu RLS est\u00e1 configurado<\/p>\n\n\n\n<h1 class=\"wp-block-heading\"><a>Dica importante<\/a><\/h1>\n\n\n\n<ol class=\"wp-block-list\" type=\"1\">\n<li>Embora no teste de fun\u00e7\u00e3o o meu usu\u00e1rio acata as configura\u00e7\u00f5es de RLS, caso eu seja administrador do Workspace as regras n\u00e3o se aplicar\u00e3o.<\/li>\n\n\n\n<li>Procure utilizar fontes online ( Sharepoint, one drive, SQL, Databricks, Dataverse etc. Caso utilize fonte local certifique que o Gateway esteja sempre atualizado para n\u00e3o perder as configura\u00e7\u00f5es de RLS.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Veja v\u00eddeo, arquivos para download e outros v\u00eddeos aqui: <a href=\"https:\/\/antunes.digital\/2023\/01\/26\/dashboard-do-zero-em-minutos\/\">https:\/\/antunes.digital\/2023\/01\/26\/dashboard-do-zero-em-minutos\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introdu\u00e7\u00e3o O RLS (Row Level Security) \u00e9 uma ferramenta do Power BI que permite limitar o acesso de usu\u00e1rios a determinados dados em um relat\u00f3rio,<a href=\"https:\/\/antunes.digital\/fabio\/2023\/04\/18\/rls-seguranca-em-nivel-de-linha\/\" class=\"read-more\">Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[29,7,28],"class_list":["post-963","post","type-post","status-publish","format-standard","hentry","category-videos","tag-dashboards","tag-powerbi-2","tag-rls","no-post-thumbnail"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/antunes.digital\/fabio\/wp-json\/wp\/v2\/posts\/963","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/antunes.digital\/fabio\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/antunes.digital\/fabio\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/antunes.digital\/fabio\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/antunes.digital\/fabio\/wp-json\/wp\/v2\/comments?post=963"}],"version-history":[{"count":2,"href":"https:\/\/antunes.digital\/fabio\/wp-json\/wp\/v2\/posts\/963\/revisions"}],"predecessor-version":[{"id":980,"href":"https:\/\/antunes.digital\/fabio\/wp-json\/wp\/v2\/posts\/963\/revisions\/980"}],"wp:attachment":[{"href":"https:\/\/antunes.digital\/fabio\/wp-json\/wp\/v2\/media?parent=963"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/antunes.digital\/fabio\/wp-json\/wp\/v2\/categories?post=963"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/antunes.digital\/fabio\/wp-json\/wp\/v2\/tags?post=963"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}