topic Will ExecuteQueries REST API Endpoint Support EffectiveIdentity? in Developer

Will ExecuteQueries REST API Endpoint Support EffectiveIdentity?

brentlightsey — Fri, 20 Aug 2021 13:52:38 GMT

We would like to call the new REST API endpoint below as an EffectiveIdentity, so that returned results are filtered by RLS rules.

New endpoint:

datasets/nnnnnn-nnnnn-nnnn-nnnn/executequeries

@Gentiana was kind enough to reply to my comment on @kayu 's original post. And it sounds like this is on the backlog for GA. We are considering starting code with that assumption, but would like to confirm if anyone can affirmatively say.

Yes, this capability will be added to the REST API endpoint
And, if there is any possibility, a guess at a timeline, even if it is in the scale of months-years.

Thanks to any for your help!

Re: Will ExecuteQueries REST API Endpoint Support EffectiveIdentity?

kayu — Fri, 20 Aug 2021 15:28:18 GMT

Hi Brent, we have it as a line item to discuss but it may or may not make it into our GA plan. If it doesn't make GA, it'll be evaluated again for a Post-GA delivery. Accordingly, we don't have a timeline yet. It'll be more in the mid term rather than the short term, I think. Hope this helps!

Re: Will ExecuteQueries REST API Endpoint Support EffectiveIdentity?

brentlightsey — Mon, 23 Aug 2021 12:59:48 GMT

Thank you for the reply @kayu . Not sure if there is an official "idea" to upvote for it, but I have 2 clients using Power BI Embedded with RLS, and they would greatly value this option.

Would it helped if I started an official "Idea" to upvote?

Re: Will ExecuteQueries REST API Endpoint Support EffectiveIdentity?

Gentiana — Mon, 28 Mar 2022 22:30:20 GMT

This is going to be part of the GA release coming very soon (April-May) of this year.