So if I understand you correctly, you have multiple dataset and each dataset is used to create a different report (different Pbix files). Then in this case each Pbix will have a separate RLS. So it will work just fine. However if you are asking how to give different permission to multiple datasets in the same pbix file then I think you can do it by creating multiple User Role tables and connecting them separately with each of your dataset. for ex: UserRole1 >> Covid_India ; UserRole2 >> Covid_USA. Hope it helps!
In addition to my previous i wnat to add one more thing is 1.your voice is very crystal clear 2.plese keep on doing more videos on Complex DAX 3.Deployement pipeline also sir
Thank you! Sure I will try to bring some videos on deployment as well. Checkout the full DAX masterclass video - ua-cam.com/video/4rC9Ow76n0U/v-deo.htmlsi=94dRzhhuLyHLxAtX
While applying RLS, you would often be in situation where many-many relationship is required. So I think its a good tool to have. However in all other scenarios, I personally try to avoid using many-many relationships.
Thanks for the feedback! I have resolved that background music issue in my latest videos. Hopefully it will not be a problem going forward. If you are using Dynamic RLS then you define the roles in the PBI desktop and don't have to setup anything on the services. Hope I answered your query!
OMG!!! I was looking for this trick for over an year. Thank you!
Happy to help! 🙂
Watched many videos for RLS security but this one was awesome and easy to understand. Thank you bro. Keep it up. Learned lot of things from you
It's my pleasure. Thanks for watching!
Superb Explanation .
Thank you 🙂
If I have many datasets so how can give separate report wise permission
So if I understand you correctly, you have multiple dataset and each dataset is used to create a different report (different Pbix files). Then in this case each Pbix will have a separate RLS. So it will work just fine.
However if you are asking how to give different permission to multiple datasets in the same pbix file then I think you can do it by creating multiple User Role tables and connecting them separately with each of your dataset. for ex: UserRole1 >> Covid_India ; UserRole2 >> Covid_USA. Hope it helps!
Great explanation... thanks so much😊
Welcome :)
Excellent explanation sir.💥💫
Thanks buddy!
In addition to my previous i wnat to add one more thing is
1.your voice is very crystal clear
2.plese keep on doing more videos on Complex DAX
3.Deployement pipeline also sir
Thank you! Sure I will try to bring some videos on deployment as well.
Checkout the full DAX masterclass video -
ua-cam.com/video/4rC9Ow76n0U/v-deo.htmlsi=94dRzhhuLyHLxAtX
Superb
Thank you! Cheers!
Very informative video! I was wondering if RLS would be implemented on the entire report, i.e all the three pages as shown in the video?
Yes, RLS will be applied on the entire report.
Great explanation👌👌👌
Thank you 😃
Nice 😊👍🏻
Thanks 😊
hello !!
is it a good idea to create primary and foreign on the table,,, some times many to many relationship cause different result in the report,,
While applying RLS, you would often be in situation where many-many relationship is required. So I think its a good tool to have. However in all other scenarios, I personally try to avoid using many-many relationships.
Very informative video. No doubt about it only issue is that background music and after publishing it to service don't we need to add the requirement?
Thanks for the feedback! I have resolved that background music issue in my latest videos. Hopefully it will not be a problem going forward.
If you are using Dynamic RLS then you define the roles in the PBI desktop and don't have to setup anything on the services. Hope I answered your query!
Thanks for great video :) , My query is the user level needs licesnce to view the dashboard ?
If you have a premium license then user can use without license. Otherwise user will also require license to see the dashboard online.
Thanks for kind reply .i want to have Power BI Premium per capacity (includes Microsoft Fabric) or Power BI Premium
per user@@pivotalstats
very helpful video, could you publish power bi services video , like deployment ,data mart , gateway , how to create mobile app.
Yes sure, ill plan something for future videos!
The music is annoying.
Noted, Thanks for the feedback !