Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Dynamic Row Level Security for multiple fields from 2 different tables

Hi,   I am working on Dynamic row level security in Power BI. I have created roles based on 'Market' based (coming from T3 table). which is working fine. (Please refer 'Market_Model image) Now, I...
Need Help
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Anonymous,

 

It seems that you have problems when you create the relationships in Power BI.

 

For your error, please change the Cross filter direction to be single and try again.

 

In addition, you could have a reference of this similar thread which has been solved.

 

If you still need help, please share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

 

Best  Regards,

Cherry

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi v-piga-msft,

 

Thank you so much for your reply.

I tried removing bidirectional relationship. But in that case Dynamic row level security for that particular field is not working.

Below is the data model after removing bidirectional relationship for 'Market'.

After applying above settings, I can see only related 'PU' but I cannot see related Market which I have defined in 'User Access' table. I am seeing all Markets now :( 

Can you please help me on that?

Thanks!

 

Regards,

Poonam