Power BI: Row-Level Security with Multiple Conditions

Sdílet
Vložit
  • čas přidán 5. 08. 2024
  • In this video, Angelica will show you how to setup row-level security in Power BI when you have multiple conditions that need to be considered. We will also look at the recent update to the row-level security editor that makes it even easier to create security roles in Power BI!
    If you haven’t already, be sure to check out my previous video where I go through the two-part process of setting up basic row-level security: • Power BI: Basic Row-Le...
    👍 If you enjoy this video and are interested in formal training on Microsoft Teams, Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Angelica30" at check out when purchasing our On-Demand Learning classes to get an extra 30% off - pragmaticworks.com/pricing/
    👍 Ready to buy now? Click this link to apply the code and subscribe now- prag.works/Angelica30
    00:00 - Introduction to Row-Level Security with Multiple Conditions
    00:38 - Reference to Basic Row-Level Security Video
    01:28 - Overview of the Power BI Report
    02:51 - Demonstration of the Updated Row-Level Security Editor Window
    04:56 - Attempt to Set Up Row-Level Security for Country and Age Separately
    06:12 - Observation of Data Mismatch When Combining Roles
    08:04 - Creating a Unified Role with Multiple Conditions (US and Ages 55+)
    10:03 - Testing and Confirmation of the Unified Row-Level Security Role
    11:18 - Conclusion and Information on Assigning Users in Power BI Service
    -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
    Next step on your journey:
    👉 On-Demand Learning - Start With The FREE Community Plan: tinyurl.com/2ujujsb5
    🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
    🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
    🔗Pragmatic Works Hackathons: pragmaticworks.com/private-tr...
    🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-me...
    🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-tr...
    🔗Pragmatic Works Blog: blog.pragmaticworks.com/
    Let's connect:
    ✔️Twitter: / pragmaticworks
    ✔️Facebook: / pragmaticworks
    ✔️Instagram: / pragmatic.works
    ✔️LinkedIn: / pragmaticworks
    ✔️CZcams: / pragmaticworks
    Pragmatic Works
    7175 Hwy 17, Suite 2 Fleming Island, FL 32003
    Phone: (904) 638-5743
    Email: training@pragmaticworks.com
    #PragmaticWorks

Komentáře • 13

  • @m.m.2209
    @m.m.2209 Před 9 měsíci

    Very helpful, thank you!

  • @tlee7028
    @tlee7028 Před rokem

    Thank you for sharing 😊

  • @emilymalkin270
    @emilymalkin270 Před rokem

    Great presentation👌!

  • @IngoJobling
    @IngoJobling Před 3 měsíci

    Excellent, thanks!

  • @isadoramoreiragomes5599

    Thank you!

  • @kedarkunte3039
    @kedarkunte3039 Před 4 měsíci

    Great Video.

  • @iSaveMe365
    @iSaveMe365 Před rokem +1

    thanks alot, muaahh

  • @user-bq3gk8eh4j
    @user-bq3gk8eh4j Před 8 měsíci

    Thank you, Angelica! it is very helpful.
    Can you demonstrate how to create a "contains text" DAX function when creating RLS?

  • @subusahu69
    @subusahu69 Před rokem

    May I know how to set up the Data Model for two RLSs?

  • @fred4287
    @fred4287 Před rokem +1

    So a report user is assigned to multiple roles, RLS filters become additive. It means report users can see table rows that represent the union of those filters

  • @ForLan48
    @ForLan48 Před rokem

    how to create the dropdown menu ( country )??? please