Need help with error message

[kattlees]

Can someone explain this error message to me? It is new in the last few days and i can't figure it out

• Data source error{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","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."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult...}}} Table: Glucometer Tests.
• Cluster URIWABI-US-NORTH-CENTRAL-B-redirect.analysis.windows.net
• Activity ID98e59c3c-c0ba-4a3a-8652-90fd52e5f827
• Request ID5b9733c6-1899-6620-1f43-857fc66c26e3
• Time2020-06-10 17:11:23Z

[v-deddai1-msft · Accepted solution]

Hi @kattlees ,

First, please check the version of Office and Power BI desktop you have installed on your machine. As described in this document, this situation often occurs when the installed version of Microsoft Office is 32-bit, and the version of Power BI Desktop installed is 64-bit. The opposite can occur as well.

Then, from the error prompt, the ACE OLEDB provider is required to connect Access database so that it can fetch data from Access. So, please download Microsoft Access Database Engine 2010 Redistributable on your machine.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[GilbertQ]

Hi there

As the error states you will need to install the 64bit version of the Access Database Engine 2010 Access Database Engine OLEDB