Forum Discussion
How to prevent unwanted access to SSAS source?
I have a typical fact table with dimensions Project, Profit Center, etc In a report, I have a table visual that shows individual numbers; and another table shows the department numbers… It lo...
NandanHegde
Super User
Super UserRather than hiding the tables, you need to create roles to filter the access for resources based on his/her use case.
otravers
Community Champion
Community ChampionThat's not the best link since Multidimensional doesn't work in Power BI. Here's the right one:
Anonymous you could also use perspectives to define which subsets of your model are viewable to your model, though that's not meant to be a security mechanism:
Both roles and perspectives are an inheritance from SSAS so they're Power BI Premium only. If you need the equivalent in Power BI Pro, you'll have to implement a combination of RLS and OLS.