Reports using Data direct in 800XA
i suspect that you have missed the post install actions required for Data Direct: login as service account, launch Excel and setup the ABB Data Direct.xla and macro security levels. Please check the Post Installation guide.
The IM Data Access and Reports have a reporting section that is good to have at hand during configuration of reports.
The problem is that the scheduler executes the File on the Aspect server and there is no DataDirect Add in enabled.
You have to install the DataDirec Add in in the on the Aspect server. You have to log in with the Service Account (800xAService) at the Aspect server (or on that server where the scheduler is executed) and enable there the DataDirect Add In in Excet.