Power BI Dashboard Scheduling error

[rmettu_1242]

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

[v-haibl-msft]

@rmettu_1242

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