Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Refresh failed (no problem with PBID)

Hello, I got a problem when I try to refresh the datas with PBI on line.   Here is the error : Erreur de source de donnéesExcel Workbook: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Anonymous,

    Do you connect to .xls Excel file and refresh it in Power BI Service? If that is the case, refreshing against a .xls file is not supported. As stated in this article, Power BI supports importing or connecting to workbooks created in Excel 2007 and later. Workbooks must be saved as .xlsx or .xlsm file type and be under 250 MB.

    To work around the above issue, you can change Excel file form type .xls to .xlsx, then you are able to refresh the dataset in Power BI Service.

    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Anonymous,

Do you connect to .xls Excel file and refresh it in Power BI Service? If that is the case, refreshing against a .xls file is not supported. As stated in this article, Power BI supports importing or connecting to workbooks created in Excel 2007 and later. Workbooks must be saved as .xlsx or .xlsm file type and be under 250 MB.

To work around the above issue, you can change Excel file form type .xls to .xlsx, then you are able to refresh the dataset in Power BI Service.

Thanks,
Lydia Zhang

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Ok,

    You're right! It's working with xlsx files.

     

    Thank you very much!