Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Data Source Error

Hello guys, hope that you are doing well. Two days ago I got this error on a schedule refresh: Data source errorDataSource.NotFound: Excel Workbook: The 'Microsoft.ACE.OLEDB.12.0' provider is not ...
  • DataVitalizer's avatar
    1 year ago

    Hi Anonymous 


    The error is due to the missing OLEDB provider, which your company doesn’t allow installing.

     

    If you want to stick with Excel, make sure the file is saved in the latest version. Alternatively, you can try saving it as a CSV and importing it that way.

     

    Moving the file to OneDrive/SharePoint and connecting via the Web/File connector could also help. 

    Did it work? 👍 A kudos would be appreciated
    🟨 Mark it as a solution to help spread knowledge 💡

     

    🟩 Follow me on LinkedIn