Forum Discussion

DashboardEMECH's avatar
DashboardEMECH
Icon for Helper II rankHelper II
5 years ago
Solved

Access Database Engine Error

Hi,   I have created a Power BI Report which reads an email from the Outlook, extracts the Excel attachment and performs the query function on the excel data.  New emails are sent every day and Pow...
Need Help
  • lbendlin's avatar
    lbendlin
    5 years ago

    yes, CSV is much better. It also loads quite a lot faster into Power BI compared to Excel.

DashboardEMECH's avatar
DashboardEMECH
Icon for Helper II rankHelper II
5 years ago

What if I use csv format instead of xls. Will that help? 

 

Also will try to see if Power Automate helps in converting an attached in the email from xls to the new format.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

yes, CSV is much better. It also loads quite a lot faster into Power BI compared to Excel.

  • DashboardEMECH's avatar
    DashboardEMECH
    Icon for Helper II rankHelper II
    5 years ago

    Tried with CSV file but the error continues 🙁

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      5 years ago

      Be more specific. What is the error now?

      • DashboardEMECH's avatar
        DashboardEMECH
        Icon for Helper II rankHelper II
        5 years ago

        The same error as the one which was getting reflected with excel file.  Reproduced below again for reference:

         

        • Processing errorExcel 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 this type of file. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987.