Forum Discussion
Solved
Unable to convert an M query in table [table name] into a native source query
Good evening, So we started having an issue with some reports that had been working fine up until today. We're getting the infamous - "Unable to convert an M query in table [table name] into a n...
So the only solution I found was to remove some of the data tranformations (data replacements, removing columns, etc..). Once I cleared those out it started to work again. From what I was able to find out from other posts, it sounds like these should not have been able to work in Direct Query mode, but they were working for at least 2 months with no issues. So even though I was able to get it to work, I don't have a true solution to the issue at the moment.
chross Yeah, that's basically what I ended up doing as well. Though our Direct Query was only out for two months. If something was changed on the MS side of things, it would have been nice to have some heads up.
