The refresh operation failed for PowerPivot on SharePoint 2010

Thursday, April 11, 2013

Yes I know. I can hardly believe it myself. I'm here again. And I'm glad to be back. So… to business! We wanted to create reports on an excel file our user was updating. We loaded the data into PowerPivot, published the Excel 2010 file into a SharePoint 2010 library and then created Panorama Flash views on top of that (and that's me making a very long story short!). The daily Excel data update worked fine until… one day it didn't. Obviously it's just a few days before a presentation to our head of department :) My colleague Tomer Horev,...

Error Processing a Cube: Key cannot be null. Parameter name: key

Wednesday, July 13, 2011

I recently opened a new project in SSAS 2008 R2. After finishing developing the cube, I deployed and processed it on the server. I got a really weird error message that meant, unfortunately enough, nothing to me: "Key cannot be null. Parameter name: key" So what's a girl to do? Well actually, I remember that every so often when I was developing a cube, I would have a problem with the data connection. The default I had defined for me when I opened a new connection was .Net Provider\SqlClient Data Provider. And somehow the default definition would always create an error...