topic Re: RLS and new embedding API in Developer

RLS and new embedding API

dmitriisolovev — Tue, 13 Jun 2017 22:07:50 GMT

Hi to all!

Can anyone give some clarity on how can we use row-level security with Power BI Premium in embedded scenarios? Should we create users in Azure AD for every user? Will RLS be supported in starter Power BI Premium plans (EM1)?

Thank you in advance!

Re: RLS and new embedding API

Eric_Zhang — Sun, 18 Jun 2017 07:21:58 GMT

@dmitriisolovev wrote:

Hi to all!

Can anyone give some clarity on how can we use row-level security with Power BI Premium in embedded scenarios? Should we create users in Azure AD for every user? Will RLS be supported in starter Power BI Premium plans (EM1)?

Thank you in advance!

@dmitriisolovev

It depends.

If Embedding with Power BI users, you'll need create users in Azure AD for every user and just set the RLS following Row-level security (RLS) with Power BI. In this scenario, RLS just works in the embedded reports as it works in Power BI Service, since each user access the report with their own account.

If Embedding with non-Power BI users, you don't have to create more than one user(for report development). There was also RLS feature for this scenario(see this link), however there's a great change happened in this case, so the content in the link doesn't make sense any longer. I'm still consulting the product team for clarification and would update in this post.

Re: RLS and new embedding API

Cleared — Tue, 20 Jun 2017 09:42:11 GMT

Any updates regarding this issue? I am also trying to Power BI Premium and the new embedded API to embedd reports, but i need to apply RLS. All I can find is how to do it using the deprecated Power Bi Embedded service in Azure...

Re: RLS and new embedding API

vickyprudhvi — Tue, 20 Jun 2017 17:16:44 GMT

@Eric_Zhang

any update on RLS feature for Non PowerBI Users

Re: RLS and new embedding API

Eric_Zhang — Wed, 21 Jun 2017 01:24:52 GMT

@vickyprudhvi

I‘ve not yet got any update from product team and I'd post the update in this post once I get any.

Re: RLS and new embedding API

Cleared — Wed, 05 Jul 2017 07:49:39 GMT

@Eric_Zhang

Still no update? My team was planning on using Power BI Embedded, and RLS was a deal-breaker for us. When the day came to start implementing it, Power BI Embedded had been deprecated and we were "forced" to use the new Power BI API. So discovering that we are unable to use RLS has put the development on hold...

Re: RLS and new embedding API

Eric_Zhang — Thu, 06 Jul 2017 06:45:11 GMT

@Cleared

The RLS feature is on the roadmap for the new "Embedding with non-Power BI users" and would come in future releases. You may use a filter as a workaround.

Otherwise you can still use the old Power BI Embedded, it will continue to be available for a limited time.

Re: RLS and new embedding API

cyan — Fri, 14 Jul 2017 14:21:54 GMT

Hi @Eric_Zhang

When approximately we should be expecting the realese of the RLS feature for non-Power BI users in the new Power BI embedded?

Thanks.

Re: RLS and new embedding API

Eric_Zhang — Mon, 17 Jul 2017 01:34:23 GMT

@cyan wrote:

Hi @Eric_Zhang

When approximately we should be expecting the realese of the RLS feature for non-Power BI users in the new Power BI embedded?

Thanks.

@cyan

Maybe in Aug, see the confirmation from Power BI staff in this post.

Re: RLS and new embedding API

dmitriisolovev — Tue, 01 Aug 2017 19:23:21 GMT

Hi @Eric_Zhang, can new customers use old Power BI Embedded service in Azure? Or it is available for those users who already used this service as at Power BI Premium GA date?

Thanks!