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

Подписаться 46 тыс.

Просмотров 17 тыс.

50% 1

Get Demo File here
ko-fi.com/s/8a400458ee
In this video we're going to go through how you can restrict your users to what columns and tables they have access to using Object-Level Security in Power BI
-
🚩 Get Demo Files here
bit.ly/3dJE2O7
👍 Become a Patreon to support the channel and get free perks!
/ solutionsabroad
🛍 Get exclusive templates built using best practices here
ko-fi.com/solutionsabroad/shop
solutionsabroad.co.uk/store
❤ Other ways to support
ko-fi.com/solutionsabroad
GET IN TOUCH
📺 Website - www.solutionsabroad.co.uk
🤵 LinkedIn - / solutionsabroad
📘 Facebook - / solutionsabroad
🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of RU-vid.
If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.
🐎 First, watch this video about how a typical Power BI workflow looks like
• Power BI from START to...
🗺 Learn DAX to extend your Power BI calculations
• Power BI DAX Basics OLD
📆 Stay up-to-date on all the features Power BI releases monthly
• Power BI Monthly Featu...
🧪 Get certified as a Microsoft Data Analyst Associate
• Power BI DA 100 Prepar...
💡 Learn Power BI Features to improve your dashboards
• Power BI Feature Highl...
📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.
🔻 Get started with Power BI Desktop for FREE
powerbi.microsoft.com/en-us/d...
#PowerBI #DataAnalytics #BusinessIntelligence

Опубликовано:

29 мар 2022

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 15

@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 9 месяцев назад

@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.

@shivangijhavar5064 2 года назад

Thanks Fernan. Very helpful !

@rajivjani8594 Год назад

Super ! Many thanks!

@nairobi203 3 месяца назад

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

@dilipinamdar5523 Месяц назад

Thank you🙏

@richmondmunez2207 3 месяца назад

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

@syedyakub5849 2 года назад

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

@SolutionsAbroad 2 года назад

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

@Bharath_PBI 2 года назад

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 2 года назад

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

@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 8 месяцев назад

having the same problem...

@bratwurstmitbiryani 2 года назад

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.