Forum Discussion
Advocate ICustomdata() - support in the datasource for on-premise Power BI Reports
Hi flopi,
From this article, we can know that
You cannot define roles within Power BI Desktop for Analysis Services live connections. You will need to do that within the Analysis Services model.
Also, per my understanding, the RLS only works when publishing Power BI reports to service, as we need to add members to roles on service site.
You could submit this idea at this page: https://ideas.powerbi.com/forums/265200-power-bi-ideas
Regards,
Yuliana Gu
Microsoft EmployeeHi flopi,
From this article, we can know that
You cannot define roles within Power BI Desktop for Analysis Services live connections. You will need to do that within the Analysis Services model.
Also, per my understanding, the RLS only works when publishing Power BI reports to service, as we need to add members to roles on service site.
You could submit this idea at this page: https://ideas.powerbi.com/forums/265200-power-bi-ideas
Regards,
Yuliana Gu
Hello,
I know this is an old post - hoping for an update or some additional comments.
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/
SSRS passes the {{USERID}} values into the connection string on connection - does PBIRS function the same way?
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()?
- flopi
Hello j_pbi_questions,
yes, it does, if you are using SSAS. Simply add Customdata() to the connection string.
BR ,
Bobi