Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
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-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
User | Count |
---|---|
65 | |
27 | |
25 | |
17 | |
11 |