Forum Discussion
Resolver IIDataSource.NotFound: Excel Workbook: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered
Hi Team, While I am refreshing my report in power bi service I am getting below error my data source for the reports are databricks and SharePoint.Can you help me.
You should avoid using .xls and .xlsb Excel files as your data source. Only .xlsx and .xlsm are safe formats.
5 Replies
- pankajnamekar25
Super User
Hello ManasRout
This error usually occurs because Power BI Service or the On-Premises Gateway is trying to access an Excel/Access file using the Microsoft.ACE.OLEDB.12.0 driver, but the driver is not installed on the gateway machine.
Since your sources are Databricks and SharePoint, check whether any hidden Excel connection, local file reference, or old query still exists in Power Query. Also verify if a gateway is being used unnecessarily.
If you are using an On-Premises Data Gateway, install the 64-bit Microsoft Access Database Engine (ACE.OLEDB.12.0) on the gateway server and restart the gateway service. After that, refresh the dataset credentials and try the scheduled refresh again.
If my response helped you, please consider clicking
Accept as Solution ✅ and giving it a Like 👍 – it helps others in the community too.
Thanks,
Connect with me on:
LinkedIn |
Data With Pankaj - YouTube
ManasRoutHi pankajnamekar25 Earlier also I have used excel file not getting any issue this is the 1st time I am getting this issue can you please explain what is hidden Excel connection, local file reference, or old query still exists in Power Query. So I will check in details.
- lbendlin
You should avoid using .xls and .xlsb Excel files as your data source. Only .xlsx and .xlsm are safe formats.
Hi ManasRout
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you.Hi ManasRout
May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.
Thank you
