Recently I used Microsoft Excel 2016 to publish a excel report to SharePoint, it gives following error when running the workbook. The workbook had a connection to BISM which is referring Analysis Services cube.
Error Message
ULS error log
The workbook '' attempted to access external data using the unsupported provider 'Provider=MSOLAP.8;
Following is the data connection I had
To resolve the issue, I had to add MSOLAP.8 to trusted data providers list.
Finally restart IIS to see the change
