Powerbi workspace Refresh error

[Deadpool_123]

Hello, I've been using On-prem gateway for PBi report for scheduled refresh option. it was working fine a month ago. Then i am getting the missing Access database engine OLEDB provider prompt since last 30 days. (There's no change in system during this time) PowerBi workspace is not refreshing any published report. Even manual refresh is also not working on PBI workspace. I am using premium capacity gateway and workspace. I am using Ms access, & SQL server as data source. 

I've tried the following troubleshooting ways, but still issue persists:  

• Verified the PBI version and ms access version, both are 64 bit. 
• Installed the Access database engine OLEDB 64 bit. 
• Checked the dataset for any data type conversion issue. 
• Installed the latest PBI desktop version and republished report. 
  
  Thanks, 

[lbendlin]

can you confirm that the 64 bit driver is installed on all gateway cluster members?  Do they all have write access to the folder that hosts the Access database?

Try not to use Access as a data source. 

[Idrissshatila]

Hello @Deadpool_123 ,

go to power query, and try to refresh the tables to see where the error is coming from.