topic Re: RSCustomDaxFilter in Report Server

RSCustomDaxFilter

JoaoFerreira — Mon, 01 Jul 2019 18:07:06 GMT

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. ?

Does anyone confirm this limitation ?

Best regards.

Re: RSCustomDaxFilter

bradsy — Tue, 02 Jul 2019 20:20:07 GMT

Can you describe your scenario more? RSCustomDaxFilter is meant to use in a dax query from PBI RS server to AS server. RS does an internal translation of the query string.

Re: RSCustomDaxFilter

JoaoFerreira — Wed, 03 Jul 2019 10:14:06 GMT

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.