Forum Discussion
DataSource.NotFound - Excel Workbook: The 'Microsoft.ACE.OLEDB.12.0'
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.
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!
3 Replies
- arvindsingh802Community Champion
Can you confirm the file type i.e. xlsx, xlx, xlxb
- andreanidouglasFrequent Visitor
xls
- arvindsingh802Community Champion
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!