Access Database Refresh Error

[cchp07]

I keep getting this error on service when I try to refresh from an Access Database. 

It will run on certain occasions, but most of the refreshes fail. 

Below is the Error... 

{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail"...

[Anonymous]

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it.

Best Regards,
Eyelyn Qin

[Anonymous]

Hi @cchp07 ,

Please follow these steps for troubleshooting:

1. The gateway is online and is the latest version. (You can check your local gateway log or use fiddler to trace the operation logs.)

2. Download the pbix file and refresh it in Power BI Desktop to rule out errors in the data source.

3. Change the Privacy Level/ Re-input the credentials 

4. Reboot.

5. If you still cannot solve the issue,sorry for that, we do not found an effective solution.We suggest you go to https://powerbi.microsoft.com/en-us/support/ ,scroll down and click "CREATE SUPPORT TICKET" for further help if you are a pro user.

Refer to:

https://community.powerbi.com/t5/Power-Query/Using-MS-Access-as-a-data-source-with-On-Premises-Data-...

https://community.powerbi.com/t5/Service/Power-BI-dataset-refresh-failing/td-p/196905

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.