Struggling with using Row-Level Security (RLS) together with Object-Level Security (OLS) in Power BI? You think it can't be done? Think again! Patrick shows you how to use both together. Announcement Blog: https://powerbi.microsoft.com/blog/object-level-security-ols-is-now-generally-available-in-power-bi-premium-and-pro/ Analysis Services Doc: https://docs.microsoft.com/analysis-services/tabular-models/object-level-security FourMoo: https://www.fourmoo.com/2020/05/26/did-you-know-you-can-now-selectively-show-report-pages-for-specific-users-in-power-bi/
Have you struggled with using Row-Level Security (RLS) on a dimension connected to two fact tables? Patrick looks at some options you can use to accomplish this in Power BI.
Using a parent/child hierarchy? Check out how we diagnose performance when using some of the PATH DAX functions in Power BI and also how to make this report faster! PATHCONTAINS Reference: https://dax.guide/pathcontains/
Have you tried measuring performance of Row-Level Security (RLS) in Power BI? How much overhead does it have? That can be a challenge using the tools we talk about. Adam shows you how you can do it! RLS Playlist: https://www.youtube.com/playlist?list=PLv2BtOtLblH1dBK34FqClo2eXXQgWW1ui RLS Course: https://guyinacu.be/rlscourse DAX Studio: https://daxstudio.org
Scenario is you want to use export to excel when viewing Power BI Row-Level Security (RLS) as someone else. RLS doesn't appear to work. Patrick breaks it down. Download Sample
Lots of folks ask if you can use groups with Power BI Row-Level Security (RLS). Patrick answers that question! Download Sample
In this video, Patrick looks at Power BI Row-Level Security And where to filter. He found that, after applying dynamic security, customers showed up in a slicer when they should not have. Challenge accepted! He walks through Power BI Desktop to show how he fixed his Row-Level Security problem.
This week we look at Power BI Desktop, KPIs and R visuals. Also, this is a special week because it is episode #52. That's one year of roundups! To celebrate and say THANK YOU, I'm giving something away! I will announce the winner in next weeks roundup! Dynamic Row Level Security with Power BI Made [...]
Several weeks ago, I had a video that talked about Row-Level Security in Power BI. Microsoft released some updates to improve this feature. Row-Level Security in Power BI Desktop Row-Level Security in Power BI has been moved to Power BI Desktop. Specifically, the steps of creating the roles and defining the DAX filters for [...]
I look at the Row-Level Security (RLS) feature within the Power BI service for Cloud models and DirectQuery. This does not cover Row-Level Security within Analysis Services as that is a different topic. This also does not look at the SQL Server Database Engine RLS feature within SQL 2016.