Тёмный
No video :(

Implement Static and Dynamic Row Level Security (RLS) in Power BI 

DataWolfs
Подписаться 4 тыс.
Просмотров 20 тыс.
50% 1

Hi In this video we are going to see how to implement static and Dynamic Row-level Security (RLS) in Power BI.
Download the Report/ Practice file from the below Link - drive.google.c...
Topics Covered
1) How to implement Static Role Level Security in Power BI
2) How to implement Dynamic Row Level Security in Power BI based on one dimension (by joining security table - USERPRINCIPALNAME Function)
3) How to implement Dynamic Row Level Security in Power Bi-based on two or more dimensions (without joining the security table using DAX)
4) Difference between static and dynamic RLS
-----------------------------------------------------------------------------------------------------------
🤵 LinkedIn - / datawolfs
📘 Facebook - / datawolfs
📸 Instagram - / datawolfs
🐤 Twitter - / datawolfs
🤖 youtube - / @datawolfs
📺 Website - datawolfs.com/
📧 Email me - info.datawolfs@gmail.com
-----------------------------------------------------------------------------------------------------------------
Most Linked Videos -
PL300 Most Important Questions - • PL 300 Exam Questions/...
Power BI Interview Questions - • Top 50 Power BI INTERV...
#PowerBI #DataAnalytics #BusinessIntelligence

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

 

28 авг 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 40   
@ramarchenav
@ramarchenav 8 месяцев назад
Thank you, I was fighting with the Dynamic RLS and your tutorial helped me.
@datawolfs
@datawolfs 8 месяцев назад
Great to hear!
@parthakotapati9
@parthakotapati9 8 месяцев назад
Very clearly explained. I am going through your documentation/videos to prep for powerBi certification and found it very useful. Great work.
@datawolfs
@datawolfs 8 месяцев назад
Thanks 🙏👍
@ravishmahajan9314
@ravishmahajan9314 Год назад
Thanks! Very clear video on RLS.
@datawolfs
@datawolfs Год назад
Thanks!!
@Powerbiwithkishore
@Powerbiwithkishore 7 месяцев назад
Excellent 👌👌👌
@datawolfs
@datawolfs 5 месяцев назад
Thanks a lot
@shomeshkrishnan7687
@shomeshkrishnan7687 2 месяца назад
Hi, Thanks much for this good explanation in Dynamic RLS. In real time we encounter to filter many dimension tables with multiple values, say here one country and one product right, say we come across with three dim tables - 5 products, 12 countries and 30 sub products. How can do that?
@SannidhiPHebbar
@SannidhiPHebbar 2 месяца назад
Very helpful
@datawolfs
@datawolfs 18 дней назад
Thanks 👍🙏
@JenMayB
@JenMayB 6 месяцев назад
Thank you. The multiple alert interruptions to like share subscribe was not good 😢
@datawolfs
@datawolfs 5 месяцев назад
Will take care in future about your experience with those
@JannePavankumar
@JannePavankumar 2 месяца назад
HI, if we share a report through embedded code we can apply security on report or not.
@Mahesh717
@Mahesh717 6 месяцев назад
then what the use of username(), if we are using userprinciplename() ?
@datawolfs
@datawolfs 5 месяцев назад
Username() is for computer 🖥️ through which user logged in. Userprinncipalname() is for mail id 🪪
@jacobocastroestrada2530
@jacobocastroestrada2530 4 месяца назад
Hello, thanks for sharing this amazing video, I want some help. In mi data set the email I want to log in I need him to see not just one product, but 3 products and 2 countries, how can I do that?
@datawolfs
@datawolfs 4 месяца назад
Yes this is possible, will create new video on it soon. Thanks
@amitgajkal4821
@amitgajkal4821 4 месяца назад
I am facing below challenge when i am uploading the file to my workspace and when trying to test it gives following error: 'To test row-level security, create a report with the semantic model and save it to the same workspace.' i used your file, not sure why am facing this challenge. Please help
@datawolfs
@datawolfs 4 месяца назад
Please delete the report and try to reupload in workspace as per video once again if some step has been missed out.
@GauravKapoor7788
@GauravKapoor7788 7 месяцев назад
Hey, can you please help me with this issue. I am able to view the changes in power bi desktop but the changes are not showing in powerbi service version. I have also added email id's of filtered people in RLS of power bi service.
@datawolfs
@datawolfs 5 месяцев назад
Follow steps in service shown in video 📷
@kafiravadh3934
@kafiravadh3934 7 месяцев назад
I am getting error. A calculated column or RLS expression on a DirectQuery table cannot reference tables from a different data source
@datawolfs
@datawolfs 5 месяцев назад
Check pbix file shared with video, if you still have problem contact on WhatsApp
@debabratapanda436
@debabratapanda436 3 месяца назад
Nice Videio. I have a query Here rather than one country if we want to have a user who while have multiple country or product access how we can do that
@bajigunturu1178
@bajigunturu1178 6 месяцев назад
Thanks bro.. We are using power bi embeded.. We don't have the email address those emails embaded in web application.. Now how can we do RLS with power bi embaded.. Plz can you make a video
@datawolfs
@datawolfs 4 месяца назад
Sure will do,but let me know what are the conditions you require here
@Iheartmusic301
@Iheartmusic301 10 месяцев назад
When I create a role through RLS and then view it as the role I created, certain visuals do not change. Do you know why this might be the case?
@eli57398
@eli57398 7 месяцев назад
You have to do it to all tables
@datawolfs
@datawolfs 5 месяцев назад
All visuals should change if they are impacted by filtering conditions of the RLS, please check filter conditions
@sanjeevkarthik3664
@sanjeevkarthik3664 5 месяцев назад
For dynamic RLS again in services level we need to add email addresses manually??
@datawolfs
@datawolfs 4 месяца назад
You can use service principle to automate
@manojsangita4181
@manojsangita4181 11 месяцев назад
keep it up
@datawolfs
@datawolfs 11 месяцев назад
Thanks
@harishs-dm8mm
@harishs-dm8mm 7 месяцев назад
can a user be able to dowload power bi report shared with the data asscociated
@datawolfs
@datawolfs 5 месяцев назад
You have an option in power bi service, you can disable and enable that
@beingrishi6450
@beingrishi6450 6 месяцев назад
7:42 Id email I'd are not present in the data then what need to be done
@datawolfs
@datawolfs 5 месяцев назад
Then you need to figure out based on what you can filter data, but email IDs are the basic things for RLS
@shreyapal2874
@shreyapal2874 9 месяцев назад
Hey! how we can download the dataset?
@datawolfs
@datawolfs 5 месяцев назад
Through website
Далее
Static and Dynamic Row Level Security in Power BI
16:28
Dynamic Row Level Security in Power BI
12:47
Просмотров 76 тыс.
I Took a LUNCHBAR OFF A Poster 🤯 #shorts
00:17
Просмотров 9 млн
娜美这是在浪费食物 #路飞#海贼王
00:20
Exploring the SEMANTIC MODEL in Power BI
27:30
Просмотров 124 тыс.