Forum Discussion

Deadpool_123's avatar
Deadpool_123
Frequent Visitor
2 years ago

Powerbi workspace Refresh error

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, 
Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    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.