This will sound really stupid, but if it works for you, I’ll at least feel less crazy. I had a similar issue where an sp_who2 on SQL would show the query running for hours, even though it should finish in like 30 seconds if run from SSMS.
Try changing the BAQ to select Top 100 Percent instead of “All Records”. For some reason, that prevented Epicor from hanging forever on the dashboard query.
I’m curious if you see the same thing. I haven’t called Epicor about this one because it sounds so ludicrous 