Forum Discussion
DAX Query fails to prepare
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.
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.
Super UserIt 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.
So the original issue pop up again but I have more info around its context.
Same report, I had to change the query a bit (different measure).
My query is a DAX query written with DAX Studio, not generated by the GUI. When I opened the query to change it. I had an error message about not being able to prepare the query, it couldn't execute in the query editor. I copied the query, wipped the query editor clean and switched to MDX. Then I switched back to DAX, pasted the exact same query. The query ran flawlessly in the query editor. Now the report takes ages to refresh (It never refreshed so far). It looks to me that the query editor doesn't like DAX not created by the GUI?
Not sure how to handle this. I cannot recreate the report each time something changes in the query.
- KNP
Anonymous - did you ever find an acceptable solution to these issues? I'm finding Power BI Report Builder, largely unusable right now.
