Tag Archives: PowerPivot

No image for PowerPivot Gallery in all Site Content SharePoint

While working on a migration project of a SharePoint 2010 to SharePoint 2013 site collection using BI, I found quite a few bugs. One of them is that, when you go in “All Site Content”, the PowerPivot Gallery doesn’t show the image, or better said, cannot show the image.

PowerPivot Gallery

No image powerpivot gallery

It’s not the biggest SharePoint bug, however it can be annoying especially for end users. I opened up Chrome Dev tools, and I found out the source of the bug… the developers did a spelling mistake in the image reference. Instead of PowerPivot… meet the new LowerPivot.

No image for PowerPivot Gallery in all Site Content SharePoint

Lowerpivot powerpivot gallery

It’s pretty hard to change the code that brings this bug and given the importance of it, it won’t probably be fixed by Microsoft soon, so here is how you can easily fix it in your farm. Navigate to “C:Program FilesCommon Filesmicrosoft sharedWeb Server Extensions14TEMPLATEIMAGESPowerPivot” and no, 14, is not a spelling mistake! Even if we are in SharePoint 2013, the picture still resides in the 14 hive.

Copy the “powerpivot_32_32.png” image, and name it “lowerpivot_32_32.png”. You will now have to exact images with different names in the layouts folder.

No image for PowerPivot Gallery in all Site Content SharePoint

lowerpivot powerpivot

At the end, everything should work well and you will see the pretty PowerPivot Gallery image!

powerpivot gallery

powerpivot gallery

Drop a comment if this helped!

Advertisements
PowerPivot Resource File not found when creating new PowerPivot Gallery Document

PowerPivot Resource File not found when creating new PowerPivot Gallery Document

While working on SharePoint 2010 to SharePoint 2013 migration, a site collection with Business Intelligence on it had quite a lot of bugs after being upgraded to 2013.. One of the bugs I found is that in a PowerPivot Gallery, whenever you want to create a new PowerPivot Gallery Document, you get this instead:

powerpivot add new document

powerpivot add new document

$Resources:PowerPivotFeatures,ReportGalleryDocumentDisplayName;

$Resources:PowerPivotFeatures,ReportGalleryDocumentDescription;

After investigating, I found out that you get the same message when you look at the PowerPivot Gallery Document content type.

PowerPivot Resource File not found when creating new PowerPivot Gallery Document

Site Content Type Information

With the info we got in those screenshots it’s pretty clear that the problem is a resource file, but why? The problem is that Microsoft, decided to rename the resource file names between SharePoint 2010 and SharePoint 2013. If you go on SharePoint 2010 in “C:Program FilesCommon FilesMicrosoft sharedWeb Server Extensions14Resources ” You will see that all the PowerPivot resource files are named “PowerPivotFeatures.resx” + language. You can view this in the image below.

powerpivot resources file location

powerpivot resources file location

However, in SharePoint 2013, when we navigate to the resource folder “C:Program FilesCommon FilesMicrosoft sharedWeb Server Extensions15Resources” , we realize that Microsoft decided to change the name of the resource file to “PowerPivot_Features.resx” As you can see an underscore is now added to the name of the file as you can see in the picture below:

PowerPivot Resource File not found when creating new PowerPivot Gallery Document

powerpivot features

Since we got our Site Collection from SharePoint 2010 to SharePoint 2013, everything still references the old resource file, which does not exist since you migrated. Unfortunately, Microsoft did not automatically fix this when you attach the Database, or when you run the “upgrade-spsite” command.

I fixed the problem by simply copying all the “PowerPivotFeatures.resx” files from SharePoint 2010 to SharePoint 2013. Since the filenames are different, you won’t have to override any SharePoint 2013 ones. So when you copy them all, your folder will look something like the screenshot below. Notice the SharePoint 2013 resource files in blue and the 2010 ones in Orange.

PowerPivot Resource File not found when creating new PowerPivot Gallery Document

powerpivot features file-location

I would do this during off hours as you may need an IISReset in order for SharePoint to pick up the new resource files.

Drop a comment if this helped!