What is row-level security in Power BI? How to implement RLS? | PL-300 Tutorials Series Ep12
Vložit
- čas přidán 31. 07. 2024
- What is row-level security in Power BI? How to implement RLS In Power BI? | PL-300 Tutorials Ep -12
This is the last episode of the DA-100 Tutorials series in which I have explained the following:
1) What is RLS?
2) What are the different types of RLS?
3) How to implement RLS in Power BI?
*Please watch our complete RLS Tutorial if you want to learn more about Row-Level Security. Check the link below*
• RLS in Power BI
Reference:
docs.microsoft.com/en-us/lear...
PL-300 Exam Sample Questions & Answers:
* PL-300 Exam Sample Questions: biconsultingpro-my.sharepoint...
*****************Free Video Tutorials*************
* Power BI Interview Questions: • Power BI Interview Que...
* Microsoft Fabric Tutorial: • Microsoft Fabric Tutorial
* DP-600 Tutorial: • DP-600 Certification T...
* DP-203 Tutorial: • DP-203: Data Engineeri...
* AZ-900 Tutorial: • AZ-900: Microsoft Azur...
* PL-300 Exam: • PL- 300 Exam Tutorial
* Power BI Tutorial for Beginners: • How to get started wit...
* Free Power BI Admin Tutorial: • How to use Power BI ad...
* Free DAX tutorial: • Complete DAX Course - ...
* Power BI Service Tutorial: • What is Power BI Servi...
* Power BI Data Modeling Tutorial: • What is Data Modeling?...
* Power Query Tutorial: • What is Power Query? H...
* RLS In Power BI: • RLS in Power BI
* Migrate to Power BI: • Migrate to Power BI
* How to choose Power BI License? - • How to choose a Power ...
* Demystifying Power BI Licenses: • Demystifying Power BI ...
* Top 5 Reasons to say Good Bye Power BI Premium: • Do you really need Pow...
************************************************************************
☎️ LET'S CONNECT!
************************************************************************
📧 Email: connect@biconsultingpro.com
📺CZcams: / @biconsultingpro
🧰LinkedIn: / biconsultingpro
🐥 Twitter: / biconsultingpr1
📱 Instagram: / biconsultingpro
➥ Facebook: / biconsultingpro
🧑💻 Website: biconsultingpro.com
Question/Answers Link: onedrive.live.com/edit.aspx?resid=B1A3DE50FFF51F92!2073&ithint=file%2cdocx&authkey=!ALKo0uNDHBolZcc
Hello i have query in this questionaire in these question there is 3 question with the different answers, just want to know which one is correct?
NO.16 You have a Microsoft Power Bl report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com. The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.
The report is a single page that contains 15 custom visuals and 10 default visuals. Users say that the report is slow to load the visuals when they access and interact with the report You need to recommend a solution to improve the performance of the report. What should you recommend? A. Split the visuals onto multiple pages. B. Implement row-level security (RLS). C. Replace the default visuals with custom visuals. D. Increase the number of times that the dataset is refreshed.
ANS: C (Replace the default visuals with custom visuals)
NO.14 You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com. The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.
The report is a single page that contains 15 AppSource visuals and 10 default visuals. Users say that the report is slow to load the visuals when they access and interact with the
report. You need to recommend a solution to improve the performance of the report. What should you recommend? A. Change any DAX measures to use iterator functions. B. Replace the default visuals with AppSource visuals. C. Change the imported dataset to DirectQuery. D. Remove unused columns from tables in the data model.
Ans: C (Change the imported dataset to DirectQuery)
Question 49:
You have a Microsoft Power Bl report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com. The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.
The report is a single page that contains 15 custom visuals and 10 default visuals. Users say that the report is slow to load the visuals when they access and interact with the report You need to recommend a solution to improve the performance of the report. What should you recommend? A. Split the visuals onto multiple pages. B. Implement row-level security (RLS). C. Replace the default visuals with custom visuals. D. Increase the number of times that the dataset is refreshed.
Answer: A (Split the visuals onto multiple pages)
Please answer commented questions,I also have a doubt
@@sushmasonker1990 May I ask you to please e-mail your doubt @ Connect@biconsultingpro.com
@@BIConsultingPro Just want to clear the confusion between these 3 similar questions.
I apologize for the incorrect answers. For the first and Last question, the Answer is "A", while for the middle one, the answer is D.
Thanks for this well produced video.. Concise and simple to understand..Thanks again...
thank you for the clear explanation.
thank you for clear explanation of RLS
Explanation- superb 💐
very nice explained. Thanks
Detailed and easy explanation. Thank you so much.
Thank you
Perfect!
You explained very well,thank you so much
You're welcome
Excellent! Thanks for sharing!
My pleasure!
It's very Helpful thank you
You are welcome
thanks for doing this.. i can understand very well.. if you possible you can do other videos on power BI .
There are plenty of video! Please check all the videos
Can we use page level security and Row level security both in a single report?
Really useful series for refreshing Power BI concepts. Thanks for sharing.
Can you please create a video with sample questions with their answers as per your experience in the DA-100 exam. That would be really helpful.
Please use this link: onedrive.live.com/edit.aspx?resid=B1A3DE50FFF51F92!2073&ithint=file%2cdocx&authkey=!ALKo0uNDHBolZcc
@@BIConsultingPro Thanks a lot
i have two tables, one has id number and sales, and the other has id number and name. i want to apply row level security on each name along with admin email, so that each employe can see only their data in services and admin can see every ones data,,... can you please help me out?
Very good video, good structure, now i get the difference between static and dynamic RLS...Could you pls. tell me the Software you´re using to create/cut this video? Thanks in advance, a satisfied subscriber...Take care...
Thank you, for your feedback! I do use canava for the animation, and iMovies for video editing. I have a RODE Mini NT microphone for voice recording.
Could you please make a video on dynamic rls with practical example since this don't give enough knowledge on dynamic rls
I'll try asap.
Thanks for this but can you also make a video to implement RLS from tables in database; which means all user entitlements are stored in tables in database and user access to be varied based on the user who logs in to Power BI service
Hi there, we have a dedicated series for RLS. Please watch this video series: czcams.com/play/PLp4MAoTwZIfc9zn1G3U8jhe9BVFOzWZ7_.html
Hi, I want to implement complex row-level security for my data, where I have organizations and sub-organizations and their path in one table and users belonging to the organization or sub-organization in another table and there are multiple users to each organization. The challenge here is when a user logs in with his credential he should see only the data related to his organization and when a person belongs to a top-level hierarchy he should see all the sub-organization's data. Can you please help me in implementing this?
To be honest, its a lot of work to do! This one, I cannot just do write away. It's not a general video. It's a requirement specific.
Hi Sir...Which data set you have used...
You can use Microsoft labs or Adventure works database
we need more complex videos on row level security
These videos are as per DA-100 exam. For more, please join our channel membership program.
Is this 12 episodes cover all DA-100 syllabus?
yes, it does cover everything. Also for Questions and answers use this: czcams.com/users/redirect?stzid=UgxIhDMER1sEonrB2vN4AaABAg&q=https%3A%2F%2Fonedrive.live.com%2Fedit.aspx%3Fresid%3DB1A3DE50FFF51F92%212073%26ithint%3Dfile%252Cdocx%26authkey%3D%21ALKo0uNDHBolZcc&event=comments&redir_token=QUFFLUhqbU5wckxVWFRNX1RrbHJrc21mdVIzZlR0SlhPUXxBQ3Jtc0tsVF9aalE3M0E4ZHhQakc1cXpkdkRwV3VJTkRJQ25PbVBwOXpnSVRYdGxCSzU4NUNaRmtNMFVYLXY2WjB6MHZSM2ZBbUctWjlXSnVXZHptaVFyWEZlN0czbndjemF4bmh3ckVaQ2oyektLYVVFaEg0SQ%3D%3D
Hi sir, what is difference between username and userprincipalname in dax. please clear my doubt. thanks
Within Power BI Desktop, username() will return a user in the format of DOMAIN\User and userprincipalname() will return a user in the format of user@contoso.com. Within the Power BI service, username() and userprincipalname() will both return the user's User Principal Name (UPN). This looks similar to an email address.
@@BIConsultingPro thanks sir reply to me . Now clear doubts
Need video on Analysis services cube security.
Please watch our tutorial on Azure Analysis Service …czcams.com/video/-of2LpP8f5Y/video.html
Hello sir ,12 videos of DA-100 exam is sufficient to crack exam
Yes, Lucky. everything is there. You can also check questions and answers. Link in the description.
Amazing video
So kind of you .. thanks a lot .
Need to know more and complex example with RLS with live projects facing difficulties.....
Sir why are you not upload more videos for DA 100 exam, please upload
Dear Sushma, I would be glad to make more videos. However, the current course is over and it's been covered in all the existing 12 videos. However, after 23rd March 2021, new topics will be there and I'll create videos for them too.
@@BIConsultingPro is this course is sufficient for DA 100
@@sushmasonker1990 Yes Sushma, it's more than sufficient. You just need to follow these video and the questions/answers I have provided
Thanks