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

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


Symptoms

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

 

Resolution

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

Comments