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.
Advocate IIIbarryHD I removed all the Replace Value steps with Conditional Columns and that seemed to work. It's just baffling to me that the Replace Values steps were in the Direct Queries for over a year and always worked until now. Hmmmm..... Again with the Replace Values steps in the desktop the report was working fine, but no longer was working in the Service.
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.