DataSource.NotFound - Excel Workbook: The 'Microsoft.ACE.OLEDB.12.0'

[andreanidouglas]

Hi,

I'm getting the following error, when trying to refresh a dataset, which is connected to an Azure Storage Gen2 Container. Per my understanding (see image below), the data is not going through any of our gateways instead going direct to the Azure container.

[arvindsingh802]

Can you confirm the file type i.e. xlsx, xlx, xlxb

[andreanidouglas]

xls

[arvindsingh802 · Accepted solution]

This is legacy file type,

Will it be possible to save the file as xlsx, if yes then you are good

If Not, you have to use Power BI Gateway and on Gateway server install Microsoft.ACE.OLEDB.12.0 Provider.

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!