Forum Discussion

pdk's avatar
pdk
New Member
9 years ago
Solved

How to Exclude Excel spreadsheet columns with confidential data before Import?

Senior Mgmt have Master Excel spreadsheets with confidential data columns. (SSN, Salary Info. etc.)   Senario 1: How do I exclude these confidential data columns from being imported to Power BI ...
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi pdk,

     

    Current power bi not support operate original source before get data.(excel not contains the additional query to config the selected columns)

     

    Perhaps you can try below methods:

    1. Make a copy of original file and remove the confidential columns, then get data from copied file.

    2. Use power query remove specific columns from source data.

     

    Reference link:

    Table.SelectColumns

    Table.RemoveColumns

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi pdk,

 

Current power bi not support operate original source before get data.(excel not contains the additional query to config the selected columns)

 

Perhaps you can try below methods:

1. Make a copy of original file and remove the confidential columns, then get data from copied file.

2. Use power query remove specific columns from source data.

 

Reference link:

Table.SelectColumns

Table.RemoveColumns

 

Regards,

Xiaoxin Sheng