Forum Discussion
Anonymous
1 year agoNot applicable
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 ...
- 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 💡
Anonymous
1 year agoNot applicable
Thank you so much for the help guys! I have solved the problem, changed from xls to xlsx and made the connection via web