Forum Discussion
Hide Tabular Models from Users?
Hi,
I have considered row level security, but the issue stems from a lack for column security. There are many columns of data in our Tabular models that we do not wish to open to users. To implement row security that would address this, we would need to:
a.) Re-configure our existing models with 'daisy chained' dimension tables that we exclude from certain users that contain the sensitive fields. This is not desirable due to the hit that user experience takes.
b.) Create two versions of the same model. One for regular use, the other for restricted.
Neither of these options is desirable. We just want to use one model, but limit users for accessing any of the data via field list or get-data. It seems this is an oversight of Power BI. This kind of security can be easily implemented in SharePoint.
Thanks,
andrew
As I said, you could implement perspectives. But you should then make sure that the complete cube should not be visible at all and you will always have the risk. Furthermore, you should then make sure that the reports are build on these perspectives.
In general, the combiniation of:
- using full cube for pre-defined reports
- not using row-level security / general restrictions
- not showing full cube to all users, but only certain columns
is not possible, as far as I know. And to be frank, for me it either seems that you have a break in your security concept or have a mistake in the process.