Dynamic Row Level Security-with Distinct Location ID

[reddy6400]

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 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  a repor With out duplicate records.

Below is the screen shot.

Thank in Advance.

Raj

[nandukrishnavs]

@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/109...

[reddy6400]

@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]

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

[nandukrishnavs]

@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)

[reddy6400]

@nandukrishnavs 

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

[nandukrishnavs]

@reddy6400 

Click on see details, and see what is the error message.