Masking personal info when connecting from api

[Anonymous]

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?

[lbendlin]

In your Power Query code remove those columns right after you retrieved the data.  That way you are minimizing the exposure.