Forum Discussion

reddy6400's avatar
reddy6400
Frequent Visitor
6 years ago

Dynamic Row Level Security-with Distinct Location ID

Hi All, Please suggest how to implement Dynamic Row Level Security for my below scenario.   I have 2 tables.One is main report data table(sales by Location) and 2nd table is Location table. My 2n...
Need Help
nandukrishnavs's avatar
nandukrishnavs
Community Champion
6 years ago

reddy6400 

 

You have to create a relationship between two tables using the Location ID column.

 

Table2[Location Id] many to one Sales_by_Location[Location Id] (Both direction)

 

 

Then create a Role in Table2.

 

[Email] = userprincipalname()

 



Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

Here is my latest blog

https://community.powerbi.com/t5/Community-Blog/Dynamic-Page-Navigation-Based-on-User-Login/ba-p/1097786

  • reddy6400's avatar
    reddy6400
    Frequent Visitor
    6 years ago

    nandukrishnavs 

     

    Sorry,Data in SALES_BY_LOCATION has same multiple Location ID's.
    I have mutile Location ID's in both the tables(many to many).

    I have to get distinct Location ID from Table 2 and join to table1.

    • reddy6400's avatar
      reddy6400
      Frequent Visitor
      6 years ago

      nandukrishnavs ..Getting below error when i join both the tables.

       

       

      • nandukrishnavs's avatar
        nandukrishnavs
        Community Champion
        6 years ago

        reddy6400 

         

        What is the error message?

         

        if your location id and sales combination is repeating, you can select both column and remove duplicate. If the sales values are different, then you can group by location id. (Edit Query)