Forum Discussion
Unable to convert an M query in table [table name] into a native source query
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.
Post PatronWell the only way I had to fix it is to remove steps that was causing it. Like above it was Replace Values steps. Once removed it worked. Do not know what caused this as I had no problems for several months. This just started showing up.
Advocate IIIRazorbx13 I'm sure we will never know what really caused this. But I'm sure a recent change in the service was the cause. There is no other explanation if your reports and mine that have been running for over several months without any problems all of the sudden have problems. 😑