cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
andrew
Regular Visitor

Hide Tabular Models from Users?

I want to be able to share reports built from Tabular models to other users, but I don't want everyone to have access to the models to build their own reports.

 

As it is right now, if I have granted read access to users on a Tabular model, then when they click on 'get data' and go to SSAS Tabular, they can see every model and make their own reports. Is there a way to allow users to see and interact with reports built from Tabular models, but not access the models via 'get data'?

5 REPLIES 5
atul_kushwaha
Frequent Visitor

@andrew Right now there is no way that can hide your tabular model from user in "Get Data" section

Bjoern
Responsive Resident
Responsive Resident

I would like to have the same feature. Some users should not be able to build their own reports.

 

Have you considered:

- Using perspectives in AS Tabular?

- Integrating row-level based security in Tabular? Then it might not have such a big impact on the users, if they could access the AS tabular cube.

 

Or is it just a "looks nice"-thing? 

 

 

andrew
Regular Visitor

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

Bjoern
Responsive Resident
Responsive Resident

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.

Greg_Deckler
Super User
Super User

It sounds like you want to build a dashboard, make sure that the tiles don't link back to the reports and give them read only to the dashboards, then they can see the information but not interact with the data/reports.


@ me in replies or I'll lose your thread!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Learn Power BI 2nd Edition

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors