Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet Reports Financials
Jet Professional
Jet Enterprise
Submit a Request
Give Feedback

Error: The pivot table could not be inserted for the following reason: Initialization of the data source failed


When creating a pivot table against the OLAP cubes in Excel the following error is encountered:



This error typically occurs when there is a mismatch of the MSOLAP driver on the machine. One cause could be certain upgraded SQL components (such as SQL Server Management Studio) that have overwritten the default MSOLAP provider in the sytem's registry while the driver itself is not present on the machine.

To resolve the issue the appropriate "SQL OLE DB Analysis Services" provider should be downloaded and installed from the Microsoft website.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request