topic Customdata() - support in the datasource for on-premise Power BI Reports in Report Server

Customdata() - support in the datasource for on-premise Power BI Reports

flopi — Thu, 20 Jul 2017 18:41:54 GMT

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

Re: Customdata() - support in the datasource for on-premise Power BI Reports

v-yulgu-msft — Fri, 21 Jul 2017 09:56:29 GMT

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

Re: Customdata() - support in the datasource for on-premise Power BI Reports

flopi — Fri, 21 Jul 2017 18:12:19 GMT

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

Re: Customdata() - support in the datasource for on-premise Power BI Reports

v-yulgu-msft — Tue, 25 Jul 2017 08:53:18 GMT

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

Re: Customdata() - support in the datasource for on-premise Power BI Reports

andreigarzon — Fri, 08 Sep 2017 01:59:20 GMT

I just get finished an environemt using CustomData() in PBIRS August Preview, so it is supported.

Re: Customdata() - support in the datasource for on-premise Power BI Reports

andreigarzon — Fri, 08 Sep 2017 02:03:15 GMT

I just get finished an environemt using CustomData() in PBIRS August Preview, so it is supported.

In PBIRS connection string add CustomData={{USERID}}

Re: Customdata() - support in the datasource for on-premise Power BI Reports

vickyprudhvi — Wed, 13 Sep 2017 12:40:09 GMT

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.

Re: Customdata() - support in the datasource for on-premise Power BI Reports

flopi — Wed, 13 Sep 2017 20:29:36 GMT

@vickyprudhviDid you let your users connectiting to SSAS with their credentials or you use a technical user ?

Re: Customdata() - support in the datasource for on-premise Power BI Reports

flopi — Wed, 13 Sep 2017 20:27:53 GMT

@andreigarzon: Are you able to change the credentials to another user in the August Release ?

Re: Customdata() - support in the datasource for on-premise Power BI Reports

andreigarzon — Thu, 14 Sep 2017 13:44:25 GMT

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.

Re: Customdata() - support in the datasource for on-premise Power BI Reports

vickyprudhvi — Thu, 14 Sep 2017 17:17:35 GMT

hi @flopi

we have our PowerI Desktop files in PowerBI Report Server (PBRS). These Pbix files are connected to tabular model live connection . Tabular Model has roles so In PBRS connection string tabe we check mark

Log in using these credentials, but then try to impersonate the user viewing the report

Option and RLS works perfectly fine.

Re: Customdata() - support in the datasource for on-premise Power BI Reports

Anonymous — Thu, 31 Jan 2019 11:33:48 GMT

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/

https://blogs.msdn.microsoft.com/sqlrsteamblog/2016/06/03/passing-user-names-to-analysis-services-with-personalized-connection-strings-in-sql-server-2016-reporting-services/

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()?

Re: Customdata() - support in the datasource for on-premise Power BI Reports

flopi — Sat, 02 Feb 2019 19:28:16 GMT

Hello j_pbi_questions,

yes, it does, if you are using SSAS. Simply add Customdata() to the connection string.

BR ,

Bobi