cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Valtyr Frequent Visitor
Frequent Visitor

Azure Analysis Services RLS and Embedding

We would like to embed reports with RLS but I'm starting to get the feeling that is not possible with Analysis Services(both Azure and on premise) using live connection in Power BI.

 

We started with on-premise analysis service (live connection) but that is not supported according to the following document:

https://docs.microsoft.com/en-us/azure/power-bi-embedded/power-bi-embedded-connect-datasource

 

Therefore, we moved the data to Azure and now we have Azure Analysis Service live connection and would like to embed that with RLS.

 

We are having problems implementing this and on the following webpage there is a note saying that Analysis Services live connections are not supported:

https://powerbi.microsoft.com/en-us/documentation/powerbi-developer-embedded-rls/

 

Is this really the case and if so when can we expect to embed RLS Power Bi reports with Analysis Service data (live connection)? Is this on the roadmap?

 

Btw, we are working with big datasets so using import instead of live connection is not really an option for us.

1 ACCEPTED SOLUTION

Accepted Solutions
Valtyr Frequent Visitor
Frequent Visitor

Re: Azure Analysis Services RLS and Embedding

I finally got this to work with PowerBi Embedding and RLS using the followingt instructions:

https://docs.microsoft.com/en-us/power-bi/developer/embedded-row-level-security#working-with-analysi...

 

Make sure that you use Customdata DAX funtion to filter the data and also that add an Azure user to the Role:

=INS_TABLE[column] = Customdata()

 

I used the sample project found here:
https://docs.microsoft.com/en-us/power-bi/developer/embed-sample-for-customers#embed-your-content-us...

 

with the following modification:

// Generate Embed Token for reports without effective identities.
var rls = new EffectiveIdentity("xxxAzureUserName", new List<string> { report.DatasetId }, new List<string>() { "SchoolFiltering" }, "SchoolName");

generateTokenRequestParameters = new GenerateTokenRequest(accessLevel: "view", identities: new List<EffectiveIdentity> { rls });

 

Hope this helps

 

 

28 REPLIES 28
Moderator Eric_Zhang
Moderator

Re: Azure Analysis Services RLS and Embedding


@Valtyr wrote:

We would like to embed reports with RLS but I'm starting to get the feeling that is not possible with Analysis Services(both Azure and on premise) using live connection in Power BI.

 

We started with on-premise analysis service (live connection) but that is not supported according to the following document:

https://docs.microsoft.com/en-us/azure/power-bi-embedded/power-bi-embedded-connect-datasource

 

Therefore, we moved the data to Azure and now we have Azure Analysis Service live connection and would like to embed that with RLS.

 

We are having problems implementing this and on the following webpage there is a note saying that Analysis Services live connections are not supported:

https://powerbi.microsoft.com/en-us/documentation/powerbi-developer-embedded-rls/

 

Is this really the case and if so when can we expect to embed RLS Power Bi reports with Analysis Service data (live connection)? Is this on the roadmap?

 

Btw, we are working with big datasets so using import instead of live connection is not really an option for us.


@Valtyr

The limitation in the second link is specific for the Embedding with non-Power BI users (app owns data). For the other embeding feature Embedding with Power BI users (users own data), the RLS shall work . The main difference between those embedding feature is on license aspect.  If you prefer live connection, use the latter approach to embed.

Valtyr Frequent Visitor
Frequent Visitor

Re: Azure Analysis Services RLS and Embedding

Thanks for the reply @Eric_Zhang.

 

I disagree that this is only a matter of licensing. It is quite inconvenient for our users to have to log into power bi when they want to access the reports. The reason why we are looking into embedding is to avoid this.

 

Will RLS with direct analysis services (app owns data) will be supported any time soon? This is quite urgent matter and I would guess that there are a lot of companies in the same situation as we are. 

Oulak Frequent Visitor
Frequent Visitor

Re: Azure Analysis Services RLS and Embedding

I concur with @Valtyr; this feature is also critical and an urgent matter for us to go forward with our PBI Embedded project.

ruiromano
Advisor

Re: Azure Analysis Services RLS and Embedding

I'm also very confused about this also.

 

I can sucessfully embed a report connecting to Azure AS (live connection) using a master account and then generating the embed token using 'GenerateTokenInGroup' (code: https://github.com/guyinacube/Embed-API-Sample).

 

But when trying to use the Identities property to use RLS I always get this error:

 

"Creating embed token for accessing dataset a5fc8daa-a34b-48b3-85fc-d76d0e21a8db requries effective identity username to be identical to the caller's principal name”

 

I dont know if it's a limitation around Power BI Embed + Azure AS or if it is somekind of configuration issue.

 

Thanks

Alex-F Visitor
Visitor

Re: Azure Analysis Services RLS and Embedding

I'm facing with the same issue as @ruiromano is.

 

Thanks

alfred1 Frequent Visitor
Frequent Visitor

Re: Azure Analysis Services RLS and Embedding

we are also facing the same issue - thought the future was supposed to be azure, not on-prem.

cmarquis Occasional Visitor
Occasional Visitor

Re: Azure Analysis Services RLS and Embedding

Running into the same situation here as well. Trying to use direct query to Azure AS with PowerBI embedded (app owns data) and need to be able to apply RLS.

 

Is there any timeline on when this will be possible?

Valtyr Frequent Visitor
Frequent Visitor

Re: Azure Analysis Services RLS and Embedding

 

I've spent so much time trying to get this to work for 'app owns' data before realizing it is not possible. Can you please confirm that RLS will work with live connection azure reports if I use the 'user owns' data method?

 

@Eric_Zhang

robrien6 Regular Visitor
Regular Visitor

Re: Azure Analysis Services RLS and Embedding

Im facing exactly the same issue.  Very little support for those paying the most in licencing costs........

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 331 members 3,607 guests
Please welcome our newest community members: