No video

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

  Рет қаралды 20,075

BI Consulting Pro

BI Consulting Pro

Күн бұрын

Пікірлер: 58
@BIConsultingPro
@BIConsultingPro 3 жыл бұрын
Question/Answers Link: onedrive.live.com/edit.aspx?resid=B1A3DE50FFF51F92!2073&ithint=file%2cdocx&authkey=!ALKo0uNDHBolZcc
@tahamansoor599
@tahamansoor599 3 жыл бұрын
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
@sushmasonker1990 3 жыл бұрын
Please answer commented questions,I also have a doubt
@BIConsultingPro
@BIConsultingPro 3 жыл бұрын
@@sushmasonker1990 May I ask you to please e-mail your doubt @ Connect@biconsultingpro.com
@tahamansoor599
@tahamansoor599 3 жыл бұрын
@@BIConsultingPro Just want to clear the confusion between these 3 similar questions.
@BIConsultingPro
@BIConsultingPro 3 жыл бұрын
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
@Laxmanmane007 3 жыл бұрын
thank you for clear explanation of RLS
@ranimaharaj-sharma4332
@ranimaharaj-sharma4332 3 жыл бұрын
Thanks for this well produced video.. Concise and simple to understand..Thanks again...
@vaibhavsiddham6274
@vaibhavsiddham6274 3 жыл бұрын
Detailed and easy explanation. Thank you so much.
@BIConsultingPro
@BIConsultingPro 3 жыл бұрын
Thank you
@vdn5716
@vdn5716 3 жыл бұрын
very nice explained. Thanks
@anujasule8077
@anujasule8077 3 жыл бұрын
thank you for the clear explanation.
@raamajoyvlogs2523
@raamajoyvlogs2523 3 жыл бұрын
Explanation- superb 💐
@alishehzadpaul
@alishehzadpaul 3 жыл бұрын
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
@BIConsultingPro 3 жыл бұрын
Please use this link: onedrive.live.com/edit.aspx?resid=B1A3DE50FFF51F92!2073&ithint=file%2cdocx&authkey=!ALKo0uNDHBolZcc
@alishehzadpaul
@alishehzadpaul 3 жыл бұрын
@@BIConsultingPro Thanks a lot
@harshavardhan4800
@harshavardhan4800 2 жыл бұрын
thanks for doing this.. i can understand very well.. if you possible you can do other videos on power BI .
@BIConsultingPro
@BIConsultingPro 2 жыл бұрын
There are plenty of video! Please check all the videos
@aloksharma2960
@aloksharma2960 2 жыл бұрын
Perfect!
@sushmasonker1990
@sushmasonker1990 3 жыл бұрын
You explained very well,thank you so much
@BIConsultingPro
@BIConsultingPro 3 жыл бұрын
You're welcome
@ItsWithinYou
@ItsWithinYou 2 жыл бұрын
Excellent! Thanks for sharing!
@BIConsultingPro
@BIConsultingPro 2 жыл бұрын
My pleasure!
@pratheep88
@pratheep88 2 жыл бұрын
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
@BIConsultingPro 2 жыл бұрын
Hi there, we have a dedicated series for RLS. Please watch this video series: kzfaq.info/sun/PLp4MAoTwZIfc9zn1G3U8jhe9BVFOzWZ7_
@rohini4062
@rohini4062 3 жыл бұрын
It's very Helpful thank you
@BIConsultingPro
@BIConsultingPro 3 жыл бұрын
You are welcome
@sandeepreddy7687
@sandeepreddy7687 3 жыл бұрын
Could you please make a video on dynamic rls with practical example since this don't give enough knowledge on dynamic rls
@BIConsultingPro
@BIConsultingPro 3 жыл бұрын
I'll try asap.
@reportingmitpowerbi
@reportingmitpowerbi 3 жыл бұрын
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
@BIConsultingPro 3 жыл бұрын
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.
@sportstv7239
@sportstv7239 2 жыл бұрын
we need more complex videos on row level security
@BIConsultingPro
@BIConsultingPro 2 жыл бұрын
These videos are as per DA-100 exam. For more, please join our channel membership program.
@naveenverma3514
@naveenverma3514 3 жыл бұрын
Can we use page level security and Row level security both in a single report?
@saikrishnaa789
@saikrishnaa789 2 жыл бұрын
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?
@aan224
@aan224 Жыл бұрын
Need video on Analysis services cube security.
@BIConsultingPro
@BIConsultingPro Жыл бұрын
Please watch our tutorial on Azure Analysis Service …kzfaq.info/get/bejne/Y9WWZa-htZ7KZY0.html
@kiranprasad1276
@kiranprasad1276 3 жыл бұрын
Is this 12 episodes cover all DA-100 syllabus?
@BIConsultingPro
@BIConsultingPro 3 жыл бұрын
yes, it does cover everything. Also for Questions and answers use this: kzfaq.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
@divyadivya3486
@divyadivya3486 3 жыл бұрын
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
@BIConsultingPro 3 жыл бұрын
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.
@zuhebkhan6973
@zuhebkhan6973 3 жыл бұрын
Hi Sir...Which data set you have used...
@BIConsultingPro
@BIConsultingPro 3 жыл бұрын
You can use Microsoft labs or Adventure works database
@raviranjansingh5527
@raviranjansingh5527 3 жыл бұрын
Hi sir, what is difference between username and userprincipalname in dax. please clear my doubt. thanks
@BIConsultingPro
@BIConsultingPro 3 жыл бұрын
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.
@raviranjansingh5527
@raviranjansingh5527 3 жыл бұрын
@@BIConsultingPro thanks sir reply to me . Now clear doubts
@Laxmanmane007
@Laxmanmane007 3 жыл бұрын
Hello sir ,12 videos of DA-100 exam is sufficient to crack exam
@BIConsultingPro
@BIConsultingPro 3 жыл бұрын
Yes, Lucky. everything is there. You can also check questions and answers. Link in the description.
@nandhakumar6480
@nandhakumar6480 3 жыл бұрын
Amazing video So kind of you .. thanks a lot . Need to know more and complex example with RLS with live projects facing difficulties.....
@sushmasonker1990
@sushmasonker1990 3 жыл бұрын
Sir why are you not upload more videos for DA 100 exam, please upload
@BIConsultingPro
@BIConsultingPro 3 жыл бұрын
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
@sushmasonker1990 3 жыл бұрын
@@BIConsultingPro is this course is sufficient for DA 100
@BIConsultingPro
@BIConsultingPro 3 жыл бұрын
@@sushmasonker1990 Yes Sushma, it's more than sufficient. You just need to follow these video and the questions/answers I have provided
@sushmasonker1990
@sushmasonker1990 3 жыл бұрын
Thanks
OMG what happened??😳 filaretiki family✨ #social
01:00
Filaretiki
Рет қаралды 13 МЛН
王子原来是假正经#艾莎
00:39
在逃的公主
Рет қаралды 15 МЛН
Static and Dynamic Row Level Security in Power BI
16:28
PK: An Excel Expert
Рет қаралды 139 М.
Power BI: Row-Level Security with Multiple Conditions
12:04
Pragmatic Works
Рет қаралды 17 М.
Dynamic Row Level Security in Power BI
12:47
RADACAD
Рет қаралды 76 М.
Why and how to use data protection in Power BI
8:11
Guy in a Cube
Рет қаралды 30 М.
OMG what happened??😳 filaretiki family✨ #social
01:00
Filaretiki
Рет қаралды 13 МЛН