Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hiding a column based on a user

Hi Folks,   Just trying to figure out something. There is a small population of users that I need to give access to the reports, but they are not allowed to see a performance rating column. Is ther...
Need Help
smowais's avatar
smowais
New Member
8 years ago

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.

 

Ivo's avatar
Ivo
Frequent Visitor
8 years ago

Hi smowais, please do as this is something that a lot of people are looking to do.

 

Thanks,

Ivo