Thursday, May 13, 2010 3:08 AM
If I create a new workbook and try and open the PowerPivot Window I get the following error:
"Initialization of the data source failed.
Check the database or contact your database administrator. Make sure the external database is avaliable, and then try to operation again.
If you see this message again, create a new data source to connect to the database."
Unable to load the VertiPaq engine.
I can open a PowerPivot workbook that I've created previously but can't create any new ones.
Any ideas/suggestions greatly appreciated.
Thursday, May 13, 2010 4:06 PMModeratorOur Analysis Services engineers are busy at the moment, but we'll get back to you at our earliest.
Monday, May 17, 2010 4:37 PMModerator
Can you confirm the versions of both Excel and PowerPivot that you are running. Also, you stated above that you can open a PowerPivot Workbook you created previously, but do not mention an attempt to open the PowerPivot Window in that workbook, can you confirm that this action works correctly?
Tuesday, May 18, 2010 11:58 PM
I'm using the RTM versions of both Office and PowerPivot (x64).
I can open the PowerPivot window in the workbook I created previously.
Wednesday, May 19, 2010 3:29 PMModerator
Can you try the following and let me know what happens:
1) Un-install the PowerPivot add-in
2) Rename the folder c:\Program files\Microsoft Analysis Services
3) Reboot the box
4) Re-install the PowerPivot add-in
- Marked As Answer by vanders Thursday, May 20, 2010 3:32 AM
Thursday, May 20, 2010 3:31 AM
That seems to have worked - thanks for your help.
Friday, August 10, 2012 6:17 PM
What troubleshooting steps can I take if this does not work? I have done this about 3 times now and I keep getting the same error.