cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
VeemalS
Frequent Visitor

Hide Tables based on user logins

Hello,

 

I have a PDBI dataset that consists of many fact tables and dimensions. However, not users will need to use or see all the tables. 

 

Using the roles creation on PBI desktop, I have been able to filter out all unwanted rows per table for each roles to be used. 

 

However, the users when they log on can still see the table header name albeit they are not able to see or use any of the data in a report that has been filtered out.

 

I want to know of there is any possibility to hide the table names so that users do not see the tables for which the data has been completely filtered out.

 

Thanks

 

Veemal

 

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

You may want to read about OLS - Object Level Security.   Note: Requires Tabular Editor.

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

You may want to read about OLS - Object Level Security.   Note: Requires Tabular Editor.

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!