Solved: Re: undefined

Anonymous · ‎01-05-2023

An error occurred in the ‘Transform File (10)’ query. DataSource.NotFound: Excel Workbook: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. The 64-bit version of the 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.

I am using one drive as data base. after refreshing I am getting above error.how can i fix this error.

css207 · ‎01-05-2023

Maybe you need to change the format of the file from ".xls" to ".xlsx".
Or you need to check the bit-version of Power BI and Office.Make sure they are same.

View solution in original post

css207 · ‎01-05-2023

Maybe you need to change the format of the file from ".xls" to ".xlsx".
Or you need to check the bit-version of Power BI and Office.Make sure they are same.