Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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.
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.
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).
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.