Forum Discussion

andreanidouglas's avatar
andreanidouglas
Frequent Visitor
4 years ago
Solved

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.

 

 

  • arvindsingh802's avatar
    arvindsingh802
    4 years ago

    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

      • arvindsingh802's avatar
        arvindsingh802
        Community 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!