Forum Discussion

Yamabushi's avatar
Yamabushi
Icon for Helper I rankHelper I
4 years ago

How does row-level security without relationships work?

Hi,   I've been reading a lot of blog posts that recommend avoiding setting up RLS with bi-directional relationships in the model. Instead, they recommend using DAX to set up the correct filters. T...
Need Help
Yamabushi's avatar
Yamabushi
Icon for Helper I rankHelper I
4 years ago

I understand the basics of RLS. I want to know technically how does the filtering work without having relationships between tables in the model.

v-chenwuz-msft's avatar
v-chenwuz-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Yamabushi ,

 

It about the context of this expression, (in another word, each row in the category will have a expend table depend on the filtering.) It contains the whole User table if there no relationship with the current table where the expression is.

 

Hope this helpful.

 

Best Regards

Community Support Team _ chenwu zhu