Troubleshoot SSRS "Query execution failed for dataset 'CashTransaction'

This was the post I was aware of speaking to similar issues.
In my case, I was able to upload the reports from local files and that fixed the issue.