Archive for January, 2015

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.

No image for PowerPivot Gallery in SharePoint All Site Content

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.

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 Files\Common Files\microsoft shared\Web Server Extensions\14\TEMPLATE\IMAGES\PowerPivot” 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.

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

Drop a comment if this helped!

Leave a comment and don’t forget to like the Absolute SharePoint Blog Page  on Facebook and to follow me on Twitter here  for the latest news and technical articles on SharePoint.  Also, don’t forget to check out SharePoint Community.Net for more great SharePoint Content.

No ratings yet.

Please rate this

Last month, I created a step by step tutorial on how to Create a SharePoint 2013 Farm in Azure Step by Step by using the new “SharePoint Farm” template in the new (and still beta) Azure portal.

One of the most popular questions I got is how much does a farm in azure cost? So, I decided to sacrifice my monthly Azure credits for the community in order to give you the exact answer.

SharePoint farm in Windows Azure cost

So by using the same step by step I started to create my farm at exactly 1PM on Day 0. I created a SharePoint farm that respects the SharePoint Minimum requirements and should be able to run a good development environment without any problems. At the moment of starting the wizard, I had exactly 157.48$ left on my MSDN Subscription.

DC SQL SharePoint
VM Template A1 A5 A4
RAM 1.75 GB 14 GB 14 GB
Number of Cores 1 2 8

 

The SharePoint Farm was successfully deployed at 2:18 PM on Day1 and I used it very lightly for about one hour.

In order to determine when exactly my credits finished, I used the email that Azure sends when your credits run out. So, I received the email at 4:48 PM on Day 8. Therefore, 157$ gives us about 194.5 hours of a SharePoint farm in Azure. So, if you work about 9h per day, for 20 days a month, that makes 180h so, provided you turn off your Virtual Machines at night, you should have enough time to run your SharePoint farm for free in Azure!

However, please note that under heavy usage, you might have a lot more bandwidth & storage usage than I did on the farm I barely even played it, so you might get a little less time than I got in this test.

If anyone has other metrics that they took from their experiments with SharePoint in Azure or tips on how to make your SharePoint farm last longer on the credit, please do not hesitate to share!

Leave a comment and don’t forget to like the Absolute SharePoint Blog Page  on Facebook and to follow me on Twitter here  for the latest news and technical articles on SharePoint.  Also, don’t forget to check out SharePoint Community.Net for more great SharePoint Content.

No ratings yet.

Please rate this

Microsoft Virtual Academy is a website created by Microsoft that has a ton of free learning material about its products. Since Office 365 is a growing trend, I decided to create a list of some SharePoint related MVA Courses you can watch whenever you want!

SharePoint Microsoft Virtual Academy

DEV:

IT Pro:

Office 365

Leave a comment and don’t forget to like the Absolute SharePoint Blog Page  on Facebook and to follow me on Twitter here  for the latest news and technical articles on SharePoint.  Also, don’t forget to check out SharePoint Community.Net for more great SharePoint Content.

No ratings yet.

Please rate this

To welcome to New Year, Microsoft Learning brought back the very popular Second Shot Offer for MCP exams! For those who are not aware, the Second Shot offer allows you to retake an exam if you failed it the first time between January 5th 2015 and May 31st 2015!

Second Shot Offer

Since Microsoft stopped dealing with Prometric, all exams are now taken at Pearson Vue testing centers and scheduled directly from your MCP portal and there is no coded needed! Here is some information about the Second Shot offer:

What exams are included in this offer?

All of the Microsoft Certified Solutions Associate (MCSA), Microsoft Certified Solutions Expert (MCSE), Microsoft Certified Solutions Developer (MCSD), and Microsoft Specialist certification exams are eligible. Microsoft Technology Associate (MTA) exams and Microsoft Office Specialist (MOS) exams do not qualify for this promotion.

How do I get my free retake?

When you register to take an MCP exam between January 5, 2015, and May 31, 2015, you become eligible for a free retake if you don’t pass it. You have 30 days from the date you took the initial exam to schedule a retake. To schedule your retake, sign in, select your exam from the exam list, and click Schedule now for free.

You can also read the Frequently Asked Questions(FAQ) over here> https://www.microsoft.com/learning/en-us/second-shot.aspx#dl-ID0EAAABBA

Second Shot Offer

To see the offer, check out the official page over here > https://www.microsoft.com/learning/en-us/second-shot.aspx

No ratings yet.

Please rate this

After migrating a Site Collection that had a PowerPivot Gallery on it from SharePoint 2010 to SharePoint 2013, I had users complaining that the PowerPivot Gallery was blank and not showing anything. My first reaction when starting to debug was “This still runs on Silverlight?” … and yes it does still run on Silverlight. The code inside the html file looks something like this:

Blank PowerPivot Gallery

Everything seemed ok and it worked in SharePoint 2010, then I realized that Microsoft renamed the “XAP” addin between SharePoint 2010 & SharePoint 2013. As you can see in the following screenshot, in SharePoint 2013 (top) it’s called “Microsoft.AnalysisServices.SPAddin.ReportGallery.xap” while in SharePoint 2010 it was called “Microsoft.AnalysisServices.ReportGallery.xap”.

Because the XAP file name is hard coded into the Silverlight file for the PowerPivot Gallery, SharePoint does not find it and therefore shows a blank gallery. To fix it, simply change the name in the HTML file for your gallery. It should look something like this in the end.

Afterwards, you save it and your Gallery should work again!

Drop a comment if this helped!

Leave a comment and don’t forget to like the Absolute SharePoint Blog Page  on Facebook and to follow me on Twitter here  for the latest news and technical articles on SharePoint.  Also, don’t forget to check out SharePoint Community.Net for more great SharePoint Content.

No ratings yet.

Please rate this