Skip to main content

Power BI

New

dynamic data masking

Vote (33) 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

1d49880c f186-4f95-8ef4-55e1c3b74091 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

6a01e747 33a3-4e57-8ebb-0cef76b4891e 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!!

Ankit Patira's profile image Profile Picture

ab2262ef e1d6-4e4a-ae6c-e94e59261f9a on 05 Jul 2020 22:39:25

RE: dynamic data masking

DataSunrise

DataSunrise Data and Database Protection is a cross-platform, {top of the line high-performing software solution for data source and data real-time security in heterogeneous environments.