Row Level Security on a DirectQuery to Power BI dataset composite model My Findings

With the DirectQuery to Power BI or Azure analysis services dataset, there are some limitations on the way that RLS (Row-level security) works. Considering that I have written a book and many blogs on this subject, It was fair to have a look at how this works. In this blog and video, you will learn about my findings, limitations, and workarounds.
Read my blog article here:

*******************

Want to learn about Power BI or AI? or take your Power BI and AI knowledge to the next level for building reports? Check out our courses in RADACAD Academy for all aspects of Power BI and AI.

*******************

********
CONNECT with US!
********

********

[justinmoorhead]

As an easier method, I have been able to get the security to apply to the import tables by setting an All Pages filter on any column in the direct query dimension. Example, if you make a fake column = 1 in your DimSalesTerritory....and then add column = 1 in the All Pages filter, it will apply the security for all connected imported tables. This might be easier than adding TreatAs on every measure.

[CRDPARTH]

Whether this issue resolved by Powerbi team ?? I am facing same issue. The scenario is I am connecting two cube's Dim tables.

[srikanthjoshi]

View as a role fior user specific will works for composite model ?

[rajtozar]

Hi - im trying to use a dataset in a new PBI report, when I link up to the data set the modelling > manage roles and view as are greyed out??? Help

When I publish to a workspace and test the RLS doesnt work, when I test in the app its fine

[noahhadro]

@RADACAD After further investigation I found out this. In "Manage Permissions" under the source power bi data set they have to have "BUILD" permissions to see the data in the other report that is using direct query. Is that how it should be? I don't want my end users to have "BUILD" permission. I only want them to have "APP" permission which from my understand is the same as "READ". Are you experiencing this?

[noahhadro]

It is really strange. to test I created a report with 1 very basic visual. it is a table with two columns. "Date" from date table and a measure "Sum(Sales_Account[Price])" from my fact table. I tried to control the variables. 1) I have RLS applied to the model and publish to the service. I start another power bi desktop model and connect to the dataset like you would prior to the new direct query feature. Then I publish to web and everything works great and all users can see the data they are suppose to. I go back to the desktop and click "make changes to model". once it makes a local model I publish the exact same way to the service and then to the app (just like I did prior to clicking "Make changes to model"). The visual breaks for all users. The only people it works for are admins of the workspace? Thoughts?