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 ...
mtaubman
Advocate I
Advocate IHi Qiuyun,
There is no Access database in this scenario. The error message mentions Access because it's the same driver used to import both Excel and Access files. In this case, there is only an xlsx file with cell data.
There is no gateway used, since the file is stored on SharePoint. In Settings, under Gateway connection, the option selected is "Connect directly". The option for "Use a data gateway" is disabled.
The error is produced by the Power BI service, not by my local machine. Naturally, I cannot install the driver, since it's running on Microsoft's machines, not my own. I do have the driver installed on my local machine, but that makes no difference here.
Could you look into this?
Regards,
Mike