fbpx

RLS with TWO Fact tables 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.

RLS with TWO Fact tables in Power BI2021-10-13T07:43:27-05:00

Case of the SLOW Power BI report: Hierarchies and RLS

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/

Case of the SLOW Power BI report: Hierarchies and RLS2021-09-02T05:11:29-05:00

Measuring RLS Performance in Power BI

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

Measuring RLS Performance in Power BI2021-07-29T05:51:31-05:00

Power BI Row-Level Security And Where To Filter

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.

Power BI Row-Level Security And Where To Filter2018-07-11T10:05:31-05:00

Power BI Desktop, R visual and more – Roundup #52

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

Power BI Desktop, R visual and more – Roundup #522016-07-07T09:17:59-05:00

Row-Level Security in Power BI – Revisited

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

Row-Level Security in Power BI – Revisited2016-07-05T13:45:35-05:00

Row-Level Security for Cloud models and DirectQuery in Power BI

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.  

Row-Level Security for Cloud models and DirectQuery in Power BI2016-06-07T20:00:13-05:00
Go to Top