Hiding a column based on a user

you cannot hide column but you can hide the value, having said that, user can have access to the value if he knows how to do things in powerbi

I believe you're asking about hiding columns based on user role and privileges. For design mode we can simply hide the columns but that would be a static approach and surely can not be workable for a large number of users and roles. 

I am investigating the same capabilities in Power BI and we know there is no such built-in feature in Power BI but I not 100% confident but I believe this could be achieved by following two ways:

1. Customized Power BI Visual Development using TypeScript and Power BI REST API

2. Dynamic data-source, even with dynamic OLAP cubes. (Performance could be a concern)

I am working on Proof-of-Concept and would share my learning soon.

Anonymous Try setting a role-based filter in power bi desktop before publishing to the cloud. Also, you can check using "view as role" before publishing.

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