Dataverse DataSet - Override Role Level Security?

[MichaelP2020]

Hi all

Does any one know if there are any plans in the pipeline for RLS enabled Data Sources to use a specified account for Dataset Execution (as opposed to the credentials of the user executing the report)?

Or, if there are any workarounds to achieve this outcome?

Thanks

Michael

[lbendlin]

Please provide more context. Right now this sounds like "I want to use RLS, but not RLS."  Please explain what you mean by "dataset execution".

[MichaelP2020]

Hi again @lbendlin. To answer your question in short, I don't want to use RLS.

To elaborate on my initial post... take the differences with the Power BI connection options of an on prem MS SQL DB vs a Dataverse Connection. The latter you aren't provided with the option to specify an alternative account to connect with when you select / specify Dataverse as your source, so would it be right to take from this, that RLS is enforced with the Dataverse Connection (at this time)?

[lbendlin]

Well, sort of. But it's not RLS, it is the restricted view that that particular developer has on the data source. Don't mix developer access and end user access paradigms.

The only time when you can say that RLS is happening in a data source is when that data source is SSAS with pass through security.