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 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-4rC9Ow76n0U.htmlsi=94dRzhhuLyHLxAtX
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!
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!
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.