Forum Discussion
Unable to convert an M query in table [table name] into a native source query
- 5 years ago
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.
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.