Forum Discussion

Razorbx13's avatar
Razorbx13
Icon for Post Patron rankPost Patron
6 years ago

Personally Identifiable Information (PII)

Hi all, have a couple of questions about this type of data.  When creating a dataset with hidden fields and tables, I am assuming they all get published to the service so that they can be used in cal...
Data Protection
  • Razorbx13's avatar
    Razorbx13
    Icon for Post Patron rankPost Patron
    6 years ago

    So if you had a field in the table, I have found that when you Analyze in Excel, it shows.  Am I doing something wrong?  For now I want to ensure any remnants of the SSN is not stored anywhere on the PowerBI service.  I know I can use the field in a calculation and remove it as my last applied step and then publish dataset, but when I refresh the dataset from the source it has to be moving from our on premises system, to the Service, then used in the calculation, then deleted.  So it must reside there somehow during the refresh process and then "removed" right?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Turn off the ability to analyze in excel. 

      when you publish the report you can deselect the option that allows the user to edit info in excel.