Forum Discussion
Solved
Direct Query behaviour with column order change
Hi everybody, I am analyzing a very weird behaviour in our data model. I tried to simplify the model as far as possible: Issue: I have 2 models, which seem absolutely identical. They have the ...
Hi IMett
Have you checked whether the M codes of all queries in both models are identical? You can click Advanced Editor to see all M codes of a query and compare it with the query in the other model. At present I couldn't think of other possible causes.
Best Regards,
Community Support Team _ Jing
Are you certain query folding is happening in both models?
Are either of the models using native queries as opposed to connecting to the tables/views?
I'd be very surprised if column order had any effect on this.