Pease correct me if I wrongly understood your issue .
You connected to other dataset via DQ connection mode in Desktop , then you refreshed you got an error . It happened in the report you created before . But if you recreate a new report via same dataset and connection mode , you can refresh the data normally , right ?
If so , what changes did you make in the original report?