Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DAX Query fails to prepare

Hi,    I have a report that is based on a DAX query. The DAX Query works fine in DAX Studio and runs in ~1 second. This query has one parameter. In the query editor, I tried with the parameter: R...
  • d_gosbell's avatar
    5 years ago

    It sounds like your data set has changed mode to an MDX query (I'm not sure what triggers this, but I have seen this setting change on it's own sometimes), if you switch it back to DAX it should resolve this issue.

     

  • Anonymous's avatar
    Anonymous
    5 years ago

    I tried this  without success, I copy pasted everything (queries + tablix) in a new blank report and that works. Maybe I switched a setting somewhere or the file was corrupted. I have no idea.

    Anyway, now that works.