Skip to main content

    Power BI

    Needs Votes

    dynamic data masking

    Vote (41) Share
    Ankit Patira's profile image

    Ankit Patira on 09 Aug 2016 15:55:42

    Row level security allows limiting number of rows returned in a visual but sometimes you have a need to display / hide certain columns. Allow dynamic data masking within power bi so that using username () function of DAX certain columns can be masked for the logged in user.

    Comments (3)
    Ankit Patira's profile image Profile Picture

    Timo Riikonen on 16 Aug 2022 11:10:15

    RE: dynamic data masking

    RLS - Row level security - has been implemented badly: It doesn't work for calculated columns at all. Then reading the RSL rule for measure and implementing it onto a calculated column is very hard (I haven't succeeded so far). So masking a column with "***" for users who don't have RLS access to the data is currently much too hard.So we need dynamic masking feature from the Power BI production team.

    Ankit Patira's profile image Profile Picture

    Jorge Adrian Power BI User on 05 Jul 2020 23:05:48

    RE: dynamic data masking

    DDM, Dynamic Data Masking within Power BI the DAX function "username () " to masked for the logged user.

    Ankit Patira's profile image Profile Picture

    jon on 05 Jul 2020 22:48:45

    RE: dynamic data masking

    The ability to pass thru DDM to data sources published via on-prem data gateway (SQL 2016) using direct query would save folks a lot of time. Having to set up the query params is a lot of hoops to jump through.. PLEASE!!