Forum Discussion
Data refresh error
HI All,
Ive built a power bi report, the data is placed on MS Teams channel in specific folder in a form of xlsx with 2 sheets.
Last 2 months there was no problem refreshing it, but today I can see this type of error when I am trying to refresh it from workspace:
Processing error: 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.
Cluster URI: WABI-NORTH-EUROPE-D-PRIMARY-redirect.analysis.windows.net
Activity ID: e6fe1497-d338-4f29-a49a-8af6ed7979b7
Or this one External table is not in the expected format when I am trying to refresh the dashboard that is located on my local files, but still linked to this teams channel - google says fix is to change xls to xlsx format, but this hasnt changed, I tried also creating new xlsx file and copy the data but no luck, and same issues.
Could you please help me and tell how to fix it?
Thank you.
Request ID: de40f1f8-8e9c-8481-a4e2-01aecbc51595
Time: 2022-02-11 15:15:41Z
HI Anonymous ,
The error complains about some data format error.
Can you try one thing:
- Remove Expanded Table step from your applied steps
- Again go and click on the icon below to add the expanded step:
Thanks,
Pragati
12 Replies
Hi Anonymous ,
when you modify file extension from .xls to .xlsx, what error do you get?
This should ideally fix this issue.
Thanks,
Pragati