Gateway fresh failing - two data sources excel and sql

[trev1972a]

Hi all

I am trying to do a bi project using two data sources - an excel file and sql. The excel file is on a shared drive and i have specified the full path within power BI desktop.

When using refresh within BI desktop it all works fine.

However when trying to refresh via the gateway i get the below error.

__

Something went wrong

There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
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: Part Information.

____

I installed Microsoft.ACE.OLEDB.12.0 (64 bit) on both the gateway machine, and the machine holding the shared file. 

I also checked the connection, it passes the connection test, and shows two sources- the excel source is shown with a full path specified.

I am completely baffled, can anyone suggest anything?

Thanks.

[nandukrishnavs · Accepted solution]

@trev1972a 

If your excel file type is not .xlsx, change it to .xlsx (Do not rename, use save as option) and see how it is working.

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

[trev1972a]

Bingo! thanks so much 🙂 i was convinced it was a gateway issue so didnt think of that

Thanks again