Dashboard security, preventing users from changing filters

[dedmondson]

How can I make it so that a user, invited to the published dashboard or report, cannot change a filter for the report nor drill down into the data?

my base data has info on multiple clients, and I'd like to set it so that Client A can see Report A but cannot change Report A to see the data on client B.

[v-yuezhe-msft]

Hi @dedmondson,

Currently, it is impossible to prevent users from changing filters. An idea about this issue has been submitted in the following idea, please vote it.  To work around this issue,  you can use Row Level Security as other post.

http://community.powerbi.com/t5/Service/Dashboard-security-preventing-users-from-changing-filters/m-...

Thanks,
Lydia Zhang

[dedmondson]

lydia, could you re send your post for the idea to be voted upon? the link you sent...is to theis same thread.

[v-yuezhe-msft]

Hi @dedmondson,

Apologize for the wrong link. Please vote this issue in the following link:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10319553-hide-filters-for-shared-...

Thanks,
Lydia Zhang

[Greg_Deckler]

You need to use Row Level Security for that, that is the only secure way.