Forum Discussion

jy2482's avatar
jy2482
Frequent Visitor
1 year ago

column level security for direct lake based model

Hi,

I have already been tried to apply field level security using Tabulor editor in the report but there are few challanges.

The report is based on a semantic model which brings data from the direct lake. Also, direct query is not a option here.

 

I am wondering if anyone can help to explain any other possible way to hide a column in the table visual for some users.

 

Thanks

4 Replies

  • jy2482 only challenge I see with CLS is if a user doesn't have access to the column the visual breaks, and it doesn't look like, it is not like the user will see all the rest of the column in the visual and not show the value for which the user doesn't have access, it just errors out. 

  • Anonymous's avatar
    Anonymous
    Not applicable

    Thank you for your prompt reply parry2k !

    Hi jy2482 

    You can refer to the following blog:
    Column Level Security - Microsoft Fabric Community 

     

     

     

     

     

     

    Best Regards,

    Jayleny

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • jy2482's avatar
    jy2482
    Frequent Visitor

    Thanks parry2k and Anonymous 

    Yes, agreed, the CLS shows error which looks like broken visual. I came across a solution to use field parameters to overcome this broken visual issue but it needs direct query when connecting to direct lake and this is not what we can choose.

    Anonymous 

    Column Level Security - Microsoft Fabric Community 

    the approoach explain in the blog, you shared the link, seems to work with the measures not the normal fields and not working in my case.

    Is there any other way to achieve it?

    Thanks 

     

  • jy2482 I think if you are using FP, it uses DQ not DL and it is a known limitation afaik.