Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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:
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.
Hello @Deadpool_123 ,
go to power query, and try to refresh the tables to see where the error is coming from.
Proud to be a Super User! | |
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
89 | |
79 | |
65 | |
64 | |
58 |
User | Count |
---|---|
171 | |
115 | |
109 | |
74 | |
69 |