Dynamic RLS

[Balhemkan]

Hello

I need your help on below issue

We have four tables

Table A: RLS Excel

Business_TYPE	Country	Country-Business	user
B2A	Germany	Germany-B2A	abc@xyz.com
B2B	Singapore	Singapore - B2B	Bca@xyz.com
B2A	Germany	Germany-B2A	Cab@xyz.com
B2B	Singapore	Singapore - B2B	daf@xyz.com

Table B: RLS Distinct Table

Country-Business

Germany-B2A

Singapore - B2B

Table C: Sales Data

Business_TYPE	Country	Country-Business	Sales
B2A	Germany	Germany-B2A	20
B2B	Singapore	Singapore - B2B	30
B2A	Germany	Germany-B2A	40
B2B	Singapore	Singapore - B2B	50

Table 😧 Country Data

Business_Type	Country-Business	Country	tax amount
B2A	Germany-B2A	Germany	50
B2A	Singapore - B2A	Singapore	90
B2A	Philipiness-B2A	Philipiness	80
B2A	America-B2A	America	44

I have Created relationship like this based on Dynamic RLS

 

By using Country data table I have created few pages . After creating dynamic RLS all the other tables is working fine except country data because it is distinct and showing Many to one relationship

When I try to join the relationship between RLS Distinct table to country data table “business-type” it showing one to one relationship and because of that data is showing mismatch.

After keeping bidirectional data is not correct and also too many mismatches.

Can you please show me some way to give relationship to Countrydata Business type column also for dynamic RLS

Note: RLS Distinct table and Country data tables having distinct values.

I created Dynamic role = username() in RLS excel table

We have exact data like given above.

Please help me

[v-yiruan-msft · Accepted solution]

Hi @Balhemkan ,

I created a sample pbix file(see attachment) for you, please check whether that is what you want.

In addition, you can refer the following links to get it.

Dynamic Row Level Security in Power BI with Exclude and Include Rules

Dynamic Row Level Security in Power BI with NOT IN or NOT EQUAL Rule

Power BI Row Level Security Many to Many Relationship

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. By the way, if one country will exist multiple business types? It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

[Balhemkan]

Hi Can someone help me

[Balhemkan]

@amitchandak  @SpartaBI @Vijay_A_Verma @tamerj1 

@lbendlin please help me