Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Valtyr
Advocate I
Advocate I

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
Valtyr
Advocate I
Advocate I

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

 

 

View solution in original post

33 REPLIES 33

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors