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

SSAS live connection string property and DAX CustomData()

Hello, 

 

This might be an old question but maybe changes/updates have changed the answer.

 

Based on some articles below - it looks like dax function CustomData(https://docs.microsoft.com/en-us/dax/customdata-function-dax) will retrieve the CustomData property of the connection string in SSAS on premise. 

 

https://www.kasperonbi.com/using-customdata-and-ssas-with-power-bi-embedded/

https://blogs.msdn.microsoft.com/sqlrsteamblog/2016/06/03/passing-user-names-to-analysis-services-wi...

 

SSRS passes the {{USERID}} values into the connection string on connection - does PBIRS function the same way when an authenticated user opens a report with CustomData={{USERID}} in the connection string on the report server webpage?

 

If there any particular function or method found in the custom forms authentication example on github that would be crucial to the resolution of this value? Would SSRS or PowerBIRS be invoking GetUserInfo()?

2 REPLIES 2
j_pbi_questions Frequent Visitor
Frequent Visitor

Re: SSAS live connection string property and DAX CustomData()

I'm confirming this is working.

 

Dax function CustomData() is returning {{USERID}} parameters from the report connection string set up in PBIRS. 

 

Some marked solutions in the forum are giving incorrect information. 

 

The finding above means you can implement a dax filter using CustomData() to acheive row level security to live connected SSAS on premise while authenticating users using an implementation like the custom security sample. 

ShaWo Frequent Visitor
Frequent Visitor

Re: SSAS live connection string property and DAX CustomData()

Oh wow! This is highly interesting. We are investigating on how to deploy federated login to SSRS and with this we could transfer the signing account info all the way to SSAS to filter the data.

Thank you for confirming this works!

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 488 members 4,068 guests
Please welcome our newest community members: