Sign Up for Training |
Jet Global Company Site
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