Forum Discussion
Azure Analysis Services RLS and Embedding
I finally got this to work with PowerBi Embedding and RLS using the followingt instructions:
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-using-the-sample-applicationwith 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
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.
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.
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?