Power BI DAX error

[Anonymous]

Hi, I have a Dataset and I am executing a DAX on that Dataset. Previously the Database was on Exasol but now its on Redshift. In Exasol the DAX was executed but on Redshift i recieve following error message:

{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"<ccon>We couldn't fold the expression to the data source. Please try a simpler expression.</ccon>"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}}],"exceptionCulprit":1}}}

I would be happy if someone has a clue.

[TomMartens]

Hey @Anonymous ,

the message " ... We couldn't fold the expression ..."
indicates that Power BI is not able to fold the DAX statement to Redshift SQL.

Either you have to rework your DAX, maybe in combination with some additional columns in your Redshift tables, or go back to Exasol, or import the data, or get rid of the measure.

Unfortunately, there is no simple solution.

Regards,

Tom