Forum Discussion
Power BI Dashboard Scheduling error
Hi Sandy,
we are tring to schedule the power BI dashboard(Data source is excel spreadsheet). we are getting below an error messages frequently. Can you please help me with this error message
Thank you
| Cluster URI: | WABI-US-EAST2-redirect.analysis.windows.net |
| Activity ID: | 718c913d-25e0-4460-bde9-a9cc1a28f08e |
| Request ID: | 5ecdf6bc-2ac7-4b59-9aa5-46fa558c030c |
| Time: | 2017-07-16 20:07:43Z |
| 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 2010 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-US-EAST2-redirect.analysis.windows.net |
| Activity ID: | b1dbfc2b-e8ff-4897-a71e-2d45dd9453d7 |
| Request ID: | 2b0ce063-65f5-4022-8c50-e0f0603d1190 |
| Time: | 2017-07-20 19:32:00Z |
1 Reply
You need to download AccessDatabaseEngine_X64.exe from https://www.microsoft.com/en-us/download/details.aspx?id=13255 and install it on your machine.
If you are using 32 bit version of Power BI Desktop and 32 bit version of AccessDatabaseEngine, you should be able to refresh the data properly in Power BI Desktop. But cannot refresh it properly in Power BI Service, becasue Power BI only have 64 bit data gateway, it is by design to leverage only 64 bits drivers.
Another solution is to use .xlsx file instead of .xls (I guess you are using this excel type).
Reference:
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-access-database-errors/
https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-onprem/
Best Regards,
Herbert
