Hide Columns or Tables using OBJECT-LEVEL SECURITY - Beginners Guide to Power BI in 2022

[@ABIDHUSSAIN-qh4hx]

I am enrolled on UDEMY but frequently coming to your channel to understand the concept. You are explaining very well. Thanks for making these videos.

[@JometVJ]

@solutions Aboard Fernan, love you man ; You made my day, any problem I face in Power BI your videos are the best and clear to understand.

[@nairobi203]

Your Videos are so helpful to understand PL300 Microsoft documentation... Thanks for sharing

[@christopherkomanee458]

Do you have to manually add everyone in your group to a new Public Role?

[@syedyakub5849]

Can we customize the error message in visual ? its better replace with "You dont have access" instead of something went wrong

[@SolutionsAbroad]

Hey Syed, unfortunately i've not found a way to do so. The method seems to simply assume that the object doesnt exist which probably is by design. If I find a way I will come back to you

[@rajivjani8594]

Super ! Many thanks!

[@RaoulDebie]

Hi Fernan, thank you for your suggested solution. I've published a model with this feature and i've shared it with a person who has viewer rights. I gave this user also the implemented RLS rights. Problem now is that my end-user can only see 'Something went wrong', where I expected to also see the possibility to select 'Fix this'. Then they would be able to see the table, but with one of the columns removed. Is there a possibility to set this up?

[@karmalin9093]

having the same problem...

[@shivangijhavar5064]

Thanks Fernan. Very helpful !

[@bandarth]

Hi, awesome video. is there a way to do the same restrictions on a measure?

[@dilipinamdar5523]

Thank you🙏

[@Bharath_PBI]

Thanks Fernan. Out of topic, I would like to get all the properties and it's values that is made available in a Power BI theme file. This is to maintain a theme file that could control all the visuals in reports in a easy way. Let me know if you have any reference to it. Thank you.

[@SolutionsAbroad]

Hi there, I would use a third-party to manage your themes, something like this: themes.powerbi.tips/

[@bratwurstmitbiryani]

Yeah, this date privacy and anonymisation hasn't been dealt with by Microsoft. I have to rely on custom security by obscurity to hide sensitive numbers from different people.

[@zme888]

disappointing this cant be done out of the box and needs tabular editor. still very cool and hopefully microsoft bring it out in power bi natively.