How To Solve Power BI Connectivity Error to Excel Sheet

You can read the Blog Below or Watch the Video As per your preference to quickly understand it.

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 .

You can view the explanation above in the video below . Subscribe to the Youtube channel by clicking on the red button to my YouTube Channel – Instrovate YouTube to not miss any Free Valuable Learning.

 

For Corporate Training reach out at info@instrovate.com 

Leave a Reply