Hiding a column based on a user

Hi Anonymous,

For your requirement, I'd like to suggest you to use query parameter to dynamic control the displayed columns.

Steps:
1. Create query parameter to store user name.
2. Create mapping table with 'user name' and 'column name' 

Sample:
User, Columns
abc, {"ColumnA","ColumnB"}
bc, {"ColumnA","ColumnB","ColumnC"}
Test, {"ColumnB"}

3. Find out the specific table column names based on above user parameter, then use it as 'table name' parameter of Table.SelectColumns function.

Reference links:

Deep Dive into Query Parameters and Power BI Templates

Table.SelectColumns

BTW, I haven't found a way to pass 'username' to query editor, so it is impossible to create dynamic table based on username.

Regards,

Xiaoxin Sheng