PowerPivot Gallery Error Could not load type ‘Microsoft.AnalysisServices.SharePoint.Integration.ReportGalleryView’

Oh no you, you got the Could not load type ‘Microsoft.AnalysisServices.SharePoint.Integration.ReportGalleryView’ error!!!  What to do now? Why did you get it? How to fix it?  All these questions are now answered! PowerPivot is a wonderful tool with a lot of power to enable self-service BI in many organizations.  There is a fine line between having users create PowerPivot reports and building an...

Backup and Restore SharePoint 2010 Site Collection with PowerShell

One of the most annoying processes with SharePoint is backing up a site collection.  There is a build in tool that you can use but it is kinda clunky and can take a while to perform the backup.  I used it once and was not impressed.  PowerShell provides a quick and easy way to do site collection backups.  My favorite part is that you can do the entire backup with one, uno, un, 1 (that’s all...

Bradley Schacht

Bradley Schacht is a Senior Program Manager on the Microsoft Azure Synapse Analytics team based in Jacksonville, FL. He has worked with Microsoft SQL Server and Azure data services since 2009 as a consultant, trainer, and architect. He has co-authored 4 SQL Server and Power BI books, most recently the Microsoft Power BI Quick Start Guide. Bradley enjoys solving interesting problems and teaching others to use new technology. He frequently presents at community events around the country, is a contributor to sites such as, and is a member of the Jacksonville SQL Server User Group (JSSUG).

Follow Me