PivotTable Operation Failed - "An error occurred while working on the Data Model in the workbook"

I recently came upon this error when clicking on slicers in a PowerPivot report published to SharePoint 2013:

Fix: Try restarting both the SQL Server Analysis Services (POWERPIVOT) service and SQL Server PowerPivot System Service

1. Restart SQL Server Analysis Services (POWERPIVOT) service
• Has to be done on the server PowerPivot was set up on -- if you do not know the server go to Central Administration > Application Management > Manage service applications > select the Excel Service Application > Data Model Settings > server name will show up here if it has been set up. If there is no server listed here then this piece of the configuration MUST be completed! Refer to this TECHNET article)


2. Restart SQL Server PowerPivot System Service
• Central Administration > System Settings > Manage services on server > Stop and start the SQL Server PowerPivot System Service

The following technet article explains service dependencies and the effects of restarting these services. I recommend reviewing this before implementing the fix: http://technet.microsoft.com/en-us/library/ee637437(v=sql.105).aspx

Coming Soon...

SharePoint 2013 Search Series

I recently had several SharePoint 2013 search projects come up. I was anxious to work on something new and especially excited to delve into a few projects of this sort. Clearly there was much to learn in order to deliver a great end product so I spent -- and continue to spend -- a bit of time becoming familiar with the new features 2013 search offers. In addition to this, SharePoint conference had some great sessions on search so I was even more pumped to get to it.

A quick go-to resource I have found more than helpful has been a series that was published on Microsoft's technet blogs. They've done a great job presenting search from the bottom up. From creating result sources to creating verticals to improve your client's search experience. Also, from playing around with display templates to custom actions on the preview panel.

The series has many topics and subtopics and can become a bit annoying if you're trying to navigate to get to a specific topic in the series. Because of this, I created a table with all the main topics and subtopics included in each post. I hope this is helpful and time saving if you decide to use this as a reference.

Search Center Overview	Create Search Center and Enable Content Crawl How to create a Search Center Site Collection How to start a full crawl in Central Administration How to enable continuous crawls in Central Administration How to set continuous crawl interval How to reindex a list
	Creating a result source and configuring Search Result Web Part How to turn off versioning for the Pages library Why you should consider creating a result source for your Search Center How to create a result source How to configure the Search Results Web Part to use a new result Source
	Search Refiners How refiners helped me plan my trip to Japan What you should look for when identifying refiners About making a managed property refinable About refinable managed properties
	Create and Add refiners to Search Results How to map a crawled property to a refinable managed property How to initiate a reindexing of a list or library How to configure the Refinement Web Part to use custom refiners How to add counts to refiner values
	Add custom Search Vertical Using a search vertical in an everyday situation About search verticals in SharePoint 2013 Result sources – why setting limits is a good thing How to create a custom search vertical What you can do after you have successfully set up a Search Center
Search Display Customization	Understanding Display Templates How search results are displayed by default About controlling how search results are displayed About result types About the connections between a result type and display templates  About display templates that are used by all result types About display template settings in the Search Results Web Part
	How Display Templates and "Hit Highlighting" work How to map your network drive Why it’s important to know about managed property names About important elements of an item display template About hit highlighting How hit highlighting works – it is magic!
	How to create a new result type About the Search Center example in this series   How to copy a default item display template How to create a result type
	How to display values from custom properties in search results - option 1 How to display a custom icon How to find a managed property name How to modify an item display template to show values from custom managed properties - option 1 About click tracking and automatically improved relevancy
	How to display values from custom properties in search results - option 2 Strategy for killing three birds with one stone - search results version How to display values from custom managed properties with hit highlighting, and get automatically improved relevancy
	How to display values from custom managed properties in the hover panel How to decide which hover panel display template to modify How to copy an existing hover panel display template How to modify a hover panel display template to show values from custom managed properties
	How to add a custom action to the hover panel What is a hover panel action? How to add an action to the hover panel
	How to change the text that is displayed in the Search Box Web Part
	How to change order of search results What was the problem again? When using query rules : define you before assign How to create a query rule that will change the order in which search results are displayed How do I know that the query rule’s been applied? Think twice before applying a query rule

May this help you find your way sooner than later

InfoPath - hide/show fields based on SharePoint groups

Thank you to all who came to my presentation this past weekend at SharePoint Saturday!

In my presentation I mentioned that you can hide/show fields based on what SharePoint group the user opening the form is a member of. 

Someone asked about how to do that and it can be found on jaliya's BLOG.

I have also found this same method very useful when multiple groups (i.e. submitter, marketing, finance, etc.) use the same form. You can create a form load rule and switch the view to the one you need the individual to go to.

If using this approach on form load, make a quick modification to Step 6 -- change the condition to "is not equal to..."

Once you've done this you'll feel like...