Rest API to query dataset with RLS

[AntonioAngel]

Hello,
I am trying to use the rest API to execute Queries In Group as:
POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/executeQueries

Nevertheless, as it states in the limitations, this is not possible with RLS.
I have ensured  the settings 'Allow service principals to use Power BI APIs' and have permissions enough to query (no RLS reports work fine).

Does anyone know if there is any workaround to query RLS datasets? Most of our reports have RLS and this is a real issue

[lbendlin · Accepted solution]

Most of our reports have RLS and this is a real issue

Couldn't have said it better.  The real issue here is RLS.  Re-evaluate if the dataset really, really needs to have RLS.

As you have mentioned, RLS and service principals are fundamentally incompatible. There is no workaround.

[AntonioAngel]

Thanks for your reply! I noticed that when I create a Power Automate flow, it allows me to query Datasets regardless of whether they are RLS or not.
Should I understand there is no way to reproduce the same with the API? (or with any other connection that can be established with R, Python, or other languages). 

[lbendlin]

I noticed that when I create a Power Automate flow, it allows me to query Datasets regardless of whether they are RLS or not.

That is not a good thing, by the way.  The reason is that in order to run dataset queries from the Power Automate action you need to specify the workspace and you need to be a member of that workspace.  That is a very unfortunate and entirely unnecessary limitation.

To work around that, write your own custom connector against the Power BI REST API.