Scheduled Refresh not working due to Old Excel 97-2003 in Sharepoint

[BayleyNZL]

Hi,

I am having issues when trying to schedule a refresh on a particular dashboard.

My data sources are from SQL (which has a gateway and working)

Data is also coming from Sharepoint files which has mutliple old 97 excel files. We are power automating data export from reports on a certain website so cannot do anything about the file, the script is currently replacing these files.

Any ideas would be great.

• Data source error[ValidateMarkupTags][ccon]DataSource.NotFound: Excel Workbook: [ccon]The 'Microsoft.ACE.#####.1#.#' provider is not registered on the local machine. The 64-bit version of the Access Database Engine OLEDB provider may be required to read this type of file.

[BayleyNZL]

Okay, what do you mean on all gateway cluster members?

Does the legacy driver need to be put on the SQL gateway?

[lbendlin]

I hope you didn't put the gateway on the same machine as the SQL server?

[lbendlin]

Exactly as the message says.  You need to install that legacy driver on all gateway cluster members.

Avoid this if you can. It will continue to give you grief.  Say no to .xls, .xlsb, and .accdb !