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,
Currently, in Power BI report server, as Power BI Reports only support live connections to Analysis Services (tabular or multidimensional), we can not using RLS in AS data source. The data source settings and Query Editor are both not editable in this mode, we are not able to fiter data rows via using Customdata() function in connection string.
Regards,
Yuliana Gu
- flopi
Hi v-yulgu-msft,
thanks for your feedback.
Do I have any possibility to use RLS with Power BI Reports, since I don't want to let my user connect to SSAS with their credentials ?
Do you plan a solution in the upcomming relese ?
Regards,
Bobi
- v-yulgu-msft
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
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()?