When you try to Connect Power BI To Excel Data Source You may get an error like below :
Details: “Excel Workbook: The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine. The 64-bit version of the Access Database Engine 2010 Access Database Engine OLEDB provider may be required to read ‘Sample – Superstore.xls’.
Or You can also say that this error is received when you try to connect Power BI to Microsoft Excel 97-2003 Worksheet
To Solve this error , The easiest way is to open your Microsoft Excel 97-2003 Data Sheet and “Save As” – Excel Workbook ( .xlsx )
Now Connect Power BI to .xlsx and your Error will be resolved .
For Corporate Training reach out at firstname.lastname@example.org