Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
We are working on a model that shows the Power BI activity across our organisation.
We would like to anonymise the user ids, so instead of showing that user A viewed that report, we want to show that there was 1 user who viewed it.
We have found a way to do this in DAX, but the challenge is that if the model is accessed via DirectQuery (not only Live) connection, then the anonymisation fails.
Do you know a way to anonymise users by using M language in Power Query Editor?
Many thanks for your answers in advance!
Solved! Go to Solution.
@KAATA , check if masking can help
https://radacad.com/show-the-information-but-not-the-details-power-bi-data-masking
@KAATA , check if masking can help
https://radacad.com/show-the-information-but-not-the-details-power-bi-data-masking
Hi @amitchandak,
Thanks a lot for your input.
I had to do the transformation in Power Query Editor, so I used the approach in the below article:
Data Masking For Sensitive Information In Power BI - Enterprise DNA
Appreciate your input,
KAATA
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |