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

Well that's an ideal solution, but the reports which are getting extracted in excel is from legacy IT system and doesn't supports xlsx format. 

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

Power BI service does not support .xls - period. Nothing you can do about it. Except maybe use Powershell or Power Automate to convert the Excel file from your legacy system to the "new" format (introduced in 2007!!!).

  • 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 🙁