I have a published report, created on the desktop, that imports data from an xlsx file stored on SharePoint. It was refreshing without issue through 2/13/2016 8:59:41 AM. Since then, every refresh ...
v-qiuyu-msft
Community Support
Community SupportHi mtaubman,
In your scenario, did the Excel file stored in SharePoint open a connection to access the Access database? After you published the report to service, did you configured any gateway used by the dataset of this report? Did you install the 32 bit Access Database Engine from this site?
Best Regards,
Qiuyun Yu