Dynamic Row Level Security-with Distinct Location ID

Question

Hi All,Please suggest how to implement Dynamic Row Level Security for my below scenario.&nbsp;I have 2 tables.One is main report data table(sales by Location) and 2nd table is Location table.My 2nd table has multiple Location Id's.I have to select Distinct location for the Email user and join that Location Id to the main data table to show the data in&nbsp; a repor With out duplicate records.&nbsp;Below is the screen shot.Thank in Advance.Raj&nbsp;&nbsp;

nandukrishnavs · Answer

reddy6400&nbsp;&nbsp;You have to create a relationship between two tables using the Location ID column.&nbsp;Table2[Location Id] many to one Sales_by_Location[Location Id] (Both direction)&nbsp;&nbsp;Then create a Role in Table2.&nbsp;[Email] = userprincipalname()&nbsp;Did I answer your question? Mark my post as a solution!Appreciate with a kudos 🙂Here is my latest bloghttps://community.powerbi.com/t5/Community-Blog/Dynamic-Page-Navigation-Based-on-User-Login/ba-p/1097786

reddy6400 · Answer

nandukrishnavs&nbsp;&nbsp;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 · Answer

nandukrishnavs&nbsp;..Getting below error when i join both the tables.&nbsp;&nbsp;

nandukrishnavs · Answer

reddy6400&nbsp;&nbsp;What is the error message?&nbsp;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)

reddy6400 · Answer

nandukrishnavs&nbsp;&nbsp;When i drag Email ID(Table-2) to the report.It is giving me below error.&nbsp;&nbsp;

Forum Discussion

Dynamic Row Level Security-with Distinct Location ID

6 Replies

Related content

Onelake security with large tables

Issue with Onelake security RLS

count distinct

Tool tip Location

Row-Level Security (RLS) with INLINE or SCHEMABINDING