Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
5 | |
4 | |
2 | |
2 |
User | Count |
---|---|
15 | |
7 | |
5 | |
3 | |
3 |