Forum Discussion

sqsjoshi's avatar
sqsjoshi
New Member
2 years ago

Very slow when using data from multiple Excel files from folder

Hello, have just installed latest version of Power BI and am finding Power BI to be extremely slow. As a test, trying to combine data from 5 Excel files with 3 worksheets each (25 columns), max of 6...
Need Help
OwenAuger's avatar
OwenAuger
Icon for Super User rankSuper User
2 years ago

Hello sqsjoshi 

Just checking, what Excel file formats are you connecting to?

Connection to the .xls and .xlsb "legacy" formats tends to be significantly slower (among other issues) as they use the Access Database Engine OLEDB (see here).

I would generally recommend .xlsx or .xlsm for this reason.

  • sqsjoshi's avatar
    sqsjoshi
    New Member
    2 years ago

    OwenAuger,

    using .xlsx files. Pl see my reply above - csv files work. There is still issue but hoping to overcome that.

     

    Looks like I need to stay away from Excel files. That would be a bummer.