Row Level Security and Direct Query

Power BI
1

Hello,

My company makes available AtScale cubes as a basis for enterprise reporting. We use the AtScale Cube connector in the Power BI Desktop with Direct Query since the cube does the necessary modeling and data is refreshed frequently.

We have a need to apply RLS against a couple of dimensions (ex. a product rollup to business units where we would assign users to a Business Unit = “Div1” role). Of course, the ‘Manage roles’ menu option under Modeling is not available in Power BI Desktop with the ‘Direct Query’ connection.

Is there an approach - documented online or on instructional video - where row level security in Power BI is available for the AtScale cube [or any] direct query?

I presume no PBIX file or additional documentation is necessary.

Thanks,
Kevin

2

Hello @kkieger,

Thank You for posting your query onto the Forum.

I’m providing a link below of an article created by Microsoft on Row Level Security where’s it applicable and what are it’s limitations.

Please go through this article and you’ll understand why the RLS option is not available/activated in your report.

Hoping you find this useful. :slightly_smiling_face:

Thanks & Warm Regards,
Harsh

3

Hi @kkieger, did the response provided by @Harsh help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark the thread as solved. Thanks!