What is row-level security in Power BI? How to implement RLS? | PL-300 Tutorials Series Ep12

[@BIConsultingPro]

Question/Answers Link: onedrive.live.com/edit.aspx?resid=B1A3DE50FFF51F92!2073&ithint=file%2cdocx&authkey=!ALKo0uNDHBolZcc

[@tahamansoor599]

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)

[@sushmasonker1990]

Please answer commented questions,I also have a doubt

[@BIConsultingPro]

@@sushmasonker1990 May I ask you to please e-mail your doubt @ [e-mail]

[@tahamansoor599]

@@BIConsultingPro Just want to clear the confusion between these 3 similar questions.

[@BIConsultingPro]

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.

[@Laxmanmane007]

thank you for clear explanation of RLS

[@ranimaharaj-sharma4332]

Thanks for this well produced video.. Concise and simple to understand..Thanks again...

[@vaibhavsiddham6274]

Detailed and easy explanation. Thank you so much.

[@BIConsultingPro]

Thank you

[@raamajoyvlogs2527]

Explanation- superb 💐

[@vdn5716]

very nice explained. Thanks

[@anujasule8077]

thank you for the clear explanation.

[@harshavardhan4800]

thanks for doing this.. i can understand very well.. if you possible you can do other videos on power BI .

[@BIConsultingPro]

There are plenty of video! Please check all the videos

[@alishehzadpaul]

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.

[@BIConsultingPro]

Please use this link: onedrive.live.com/edit.aspx?resid=B1A3DE50FFF51F92!2073&ithint=file%2cdocx&authkey=!ALKo0uNDHBolZcc

[@alishehzadpaul]

@@BIConsultingPro Thanks a lot

[@ItsWithinYou]

Excellent! Thanks for sharing!

[@BIConsultingPro]

My pleasure!

[@sportstv7239]

we need more complex videos on row level security

[@BIConsultingPro]

These videos are as per DA-100 exam. For more, please join our channel membership program.

[@pratheep88]

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

[@BIConsultingPro]

Hi there, we have a dedicated series for RLS. Please watch this video series: kzbin.info/aero/PLp4MAoTwZIfc9zn1G3U8jhe9BVFOzWZ7_

[@sandeepreddy7687]

Could you please make a video on dynamic rls with practical example since this don't give enough knowledge on dynamic rls

[@BIConsultingPro]

I'll try asap.

[@naveenverma3514]

Can we use page level security and Row level security both in a single report?

[@sushmasonker1990]

You explained very well,thank you so much

[@BIConsultingPro]

You're welcome

[@zuhebkhan6973]

Hi Sir...Which data set you have used...

[@BIConsultingPro]

You can use Microsoft labs or Adventure works database

[@rohini4062]

It's very Helpful thank you

[@BIConsultingPro]

You are welcome

[@saikrishnaa789]

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?

[@aloksharma2960]

Perfect!

[@kiranprasad1276]

Is this 12 episodes cover all DA-100 syllabus?

[@BIConsultingPro]

yes, it does cover everything. Also for Questions and answers use this: kzbin.info?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

[@reportingmitpowerbi]

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

[@BIConsultingPro]

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.

[@aan224]

Need video on Analysis services cube security.

[@BIConsultingPro]

Please watch our tutorial on Azure Analysis Service …kzbin.info/www/bejne/Y6DJY3-mhZ2Za7s

[@divyadivya3486]

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?

[@BIConsultingPro]

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.

[@raviranjansingh5527]

Hi sir, what is difference between username and userprincipalname in dax. please clear my doubt. thanks

[@BIConsultingPro]

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 [e-mail]. 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.

[@raviranjansingh5527]

@@BIConsultingPro thanks sir reply to me . Now clear doubts

[@Laxmanmane007]

Hello sir ,12 videos of DA-100 exam is sufficient to crack exam

[@BIConsultingPro]

Yes, Lucky. everything is there. You can also check questions and answers. Link in the description.

[@nandhakumar6480]

Amazing video So kind of you .. thanks a lot . Need to know more and complex example with RLS with live projects facing difficulties.....

[@sushmasonker1990]

Sir why are you not upload more videos for DA 100 exam, please upload

[@BIConsultingPro]

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.

[@sushmasonker1990]

@@BIConsultingPro is this course is sufficient for DA 100

[@BIConsultingPro]

@@sushmasonker1990 Yes Sushma, it's more than sufficient. You just need to follow these video and the questions/answers I have provided

[@sushmasonker1990]

Thanks