Forum Discussion

JoaoFerreira's avatar
JoaoFerreira
New Member
7 years ago

RSCustomDaxFilter

RSCustomDaxFilter seems to generate an error when running on a datasource using powerbi report server. If I connect directly the RDL to azure AS it will work. Is there a workaround for this issue. ...
PBI Report Server
JoaoFerreira's avatar
JoaoFerreira
New Member
7 years ago

So i have this (for testing) simple dataset

EVALUATE SUMMARIZECOLUMNS('Date'[Year], RSCustomDaxFilter(@DateYear,EqualToCondition,[Date].[Year],Int64))

 

And let's say i choose 2018 and 2019, and with the RDL connected directly to Azure analysis services (asazure://northeurope.asazure.windows.net/servernameeeeee) it will work fine.

 

Let say i publish this to PBI report server and change to a shared Datasource connected to the same server (as i do with all reports on report server) it will stop working.

 

At the report server log i get

processing!ReportServer_0-5!27f8!07/03/2019-10:09:06:: e ERROR: An exception has occurred in data set 'DataSet1'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'DataSet1'. ---> Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: Query (1, 41) Failed to resolve name 'RSCustomDaxFilter'. It is not a valid table, variable, or function name.

 

Best regards.