Forum Discussion
Anonymous
1 year agoNot applicable
Masking personal info when connecting from api
Hello all,
I'm working with an api that includes personal info such as ssn, unfortunately the api does not qllow us to filter out sensitive info before retrieving it.
I would like to know if there's a way to mask or hide this sensitive data directly within pbi during the connection process so that the developers do not see the unmasked ssn. If this is not possible, are there any best practices or another approach?
1 Reply
- lbendlinSuper User
In your Power Query code remove those columns right after you retrieved the data. That way you are minimizing the exposure.