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.

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

Don't use .xls files.  Migrate to .xlsx file format.

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