Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Power BI DAX error

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.

Dataflow
Need Help

1 Reply

  • TomMartens's avatar
    TomMartens
    Super User
    2 years ago

    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