Data Science Wire

OneLake Security, CLS into RLS to prevent visual from breaking

Reddit r/MicrosoftFabric1mo5 min read

Hello πŸ˜„ I just wanted to share with the community a trick I found while working on a Power BI report with OneLake Security enabled. The first issue encountered was with Column-level Security (CLS), namely when using CLS, if a user doesn't have access to a column used in a visual it will return an error. This behavior is different than Row-level Security (RLS), with RLS, if a user doesn't have access to specific rows of a table that could appear in a visual, they are just not shown. So no visuals break. I did expect the same with CLS (that the column would just disappear and all the other ones

Read the full story at Reddit r/MicrosoftFabric β†’

More in Analytics Engineering