locked
MS Query...cannot write sorted rows error RRS feed

  • Question

  • I have an MS Query report crated and it was working well until i tried to remove a Criteria Filter within the query. I get an error "Cannot Write Sorted Row". If I acknowledge the error, the change to the criteria is not saved and it reverts to the original setting. I had several columns sorted, of which i deleted the SQL code for sort thinking that may help. I also tried to delete the Criteria Filter via the wizard and directly in SQL but that did not help.

    Any suggestions of what may be the issue?

    Thursday, April 16, 2015 4:13 PM

Answers

  • This is a Power Query forum and so it's unlikely you'll find MS Query experts here. That being said, did you try using Power Query for your scenario?

    • Proposed as answer by Michael Amadi Sunday, April 19, 2015 11:59 AM
    • Marked as answer by Michael Amadi Monday, May 4, 2015 10:33 PM
    Friday, April 17, 2015 1:20 AM