Forum Discussion
Advocate ICustomdata() - support in the datasource for on-premise Power BI Reports
Hi,
could you please comment, if the customdata()-function is going to be supported for Power BI Reports on the Power BI Reportserver ?
Both paginated and mobile Reports are working great and and user credentials are properly forwerded to the SSAS instance, as it is described in the MSDN post . Since Power BI Reportserver is a superset of SSRS 2016 and its features, my expection was that the customdata() is available for Power BI Reports, too.
Best Regards,
Bobi
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
12 Replies
v-yulgu-msftMicrosoft Employee
Hi 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
Hi
I just get finished an environemt using CustomData() in PBIRS August Preview, so it is supported.
- flopi
andreigarzon: Are you able to change the credentials to another user in the August Release ?
I am using PBIRS with Forms Authentication. In this scenario PBIRS can connect to SSAS with a predefined user, but in the connection string you can add CustomData={{USERID}} to get the Forms Authenticated User and pass this user to SSAS to achieve RLS.
Hi
I just get finished an environemt using CustomData() in PBIRS August Preview, so it is supported.
In PBIRS connection string add CustomData={{USERID}}
vickyprudhviHelper IV
we are using RLS for our Pbix files that are in PowerBI Report Server. RLS needs to be in Tabular model with Live connection and its working well.
- flopi
vickyprudhviDid you let your users connectiting to SSAS with their credentials or you use a technical user ?
