Loading embedded data issue with PowerPivot & Excel 2010

Hi,

I had to struggle with this for 3 hours yesterday! Finally found the link below and with some toggling between the PowerPivot window and Excel if finally became stable. Looks like it's definitely an issue with the Vertipaq data compression engine but this seems to be stabilizing it for my project. I'm running some tests between PP and a standard Access database (pre-Access 2007 too) so there shouldn't be this kind of a problem. I shudder to think what a client would think of this kind of workaround though.


http://support.microsoft.com/kb/2025669

I'm getting the same error as the original gentleman in this thread. It's not the Vertipaq error mentioned later. Is there any resolution you've found?

Hi folks,

I'm a member of the PowerPivot team and if you guys are still getting these issues, I would love to get a handle on your corrupt files if possible.

If you're willing, my email address is ashvini.sharma at microsoft dot com.

regards

Hi Ashani,

I'm still having this issue and sent you an email about it. Hopefully we can figure out what is going on here. I'm working on a project for a potential full-time job so this is very important to me to get it right.

The source data are Excel files and I'm getting the standard error messages ("The Embedded PowerPivot data is corrupt" and "Unable to load the VertiPaq Engine"). This happens if I link to the source or if I just copy and paste directly into PowerPivot.

My only thought now is that there is something about the data or headers in the first row that are causing PowerPivot to hiccup. Any thoughts on this or, better yet, to work with me on a solution would be immensely appreciated.


Jeff Stevens

We are currently experiencing this same issue. Was the source of the problem identified?

Struggled with this issue for days and days.....

I had downloaded PowerPivot for excel from www.PowerPivot.com, which I've read somewhere is a CTP version.

After uninstalling this version, renaming Microsoft Analysis Services folder in program files, rebooting my laptop and installing the latest RTM version (http://go.microsoft.com/fwlink/?LinkId=155905) it worked.

Hope this helps someone...

J-Dawg

after a few days of fighting with this error we realized that Trend Micro Internet Security was the culprit. Disabling real-time protection helped in our case.