topic Re: Rest API to query dataset with RLS in Developer

Rest API to query dataset with RLS

AntonioAngel — Fri, 27 Oct 2023 13:54:39 GMT

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

Re: Rest API to query dataset with RLS

lbendlin — Sat, 28 Oct 2023 21:00:26 GMT

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.

Re: Rest API to query dataset with RLS

AntonioAngel — Thu, 02 Nov 2023 07:41:31 GMT

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).

Re: Rest API to query dataset with RLS

lbendlin — Thu, 02 Nov 2023 19:35:46 GMT

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.