Data Source Error

[gcompliance]

Data source is sharepoint, I use powerapps to create a flow from reports I receive in my inbox to sharepoint and refresh the data. This is my first time receivign this error. 

Data source error: {"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"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."}}],"exceptionCulprit":1}}} Table: Query1.
Cluster URI: WABI-WEST-US-redirect.analysis.windows.net
Activity ID: 00000000-0000-0000-0000-000000000000
Request ID: 2d72f176-e527-4f00-a9e7-3dfdb5488086
Time: 2021-03-11 20:16:57Z

[gcompliance]

I think I solved this myself but would like another opinion. Is it saying that my Microsoft Office is 32-bit, and the version of Power BI Desktop installed is 64-bit? or the other way around?

[aj1973 · Accepted solution]

Hi @gcompliance 

It says that you have a 32 bit Access data engine in your machine and you need a 64 bit.

Know that it is better to use 64 bit versions (Power BI desktop and Source) from the get going if you are planning to use Power bi Gateway to refresh your reports in the service.