It would really be interesting to see how one can implement RLS on hierarchical tables shown in your example by leveraging these functions. Can you please create one video for the same?
You should create a key for the duplicated node and use that column to create the path. One key could be the path to the node - but of course you cannot obtain it by using the DAX function.
It would really be interesting to see how one can implement RLS on hierarchical tables shown in your example by leveraging these functions. Can you please create one video for the same?
finished WATCHING
Thank you
Thank you 👍
These functions give an error if I have child value having more than 1 parent value. Is there any way to make them work in such a data scenario?
You should create a key for the duplicated node and use that column to create the path. One key could be the path to the node - but of course you cannot obtain it by using the DAX function.