Error while processing Schedule Refresh where the Desktop refresh succeeds

[HaveeshPerla_1]

Hi Team,

I'm using MS Access DB file as my data source which is located in sharepoint. Getting the data and building the report is all going smooth. Also, I'm able to refresh the file in Power BI Desktop file without any issues.

Whereas, while scheduling the report in Web I'm getting the below error.

 Please help to guide me to get rid of this error. 

[v-shex-msft]

HI @HaveeshPerla_1,

Can you please share some more detail about these? (e.g. type of data connector, encryption enabled on your database file...) They will help us clarify your scenario and test to troubleshoot.

How to Get Your Question Answered Quickly  

In addition, have you installed the corresponding data driver on your device? As the document said, the Access database requirement gateway to handle refresh.

Power BI data sources - Power BI | Microsoft Docs

Regards,

Xiaoxin Sheng

[HaveeshPerla_1]

Hi,

As per my understanding to your question the data connector used is Access DB file from the Sharepoint. I've called the file through Get Data>Web> and the Access DB file path in the sharepoint. I imported data and built the report successfully. 

I'm only facing the issue when i'm trying to schedule the refresh in Power Bi service(Web), where I'm able to refresh in the desktop copy.

I've also installed the Microsoft Accessdatabase Enginex64 (https://www.microsoft.com/en-us/download/details.aspx?id=54920) post getting the error, but I could still see the same error even after installation.

Kindly help to guide ASAP if i need to configure aything post installation or any alternative to make the Access DB based power Bi file get scheduled in the service. 

Error :

Processing error:	Microsoft Access: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. The 64-bit version of the Access Database Engine OLEDB provider may be required to read this type of file. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987.
Cluster URI:	WABI-SOUTH-EAST-ASIA-B-PRIMARY-redirect.analysis.windows.net
Activity ID:	01ea9cbb-da1a-4339-8123-80e03fdc05c1
Request ID:	3fb4907d-5ad3-5921-4232-bf5554cb4717
Time:	2022-04-20 11:54:01Z