The Baretta

Today we will be learning how to create a excel report connected to a SharePoint library using Power Query.  I will also address all issues found along the way. The reason we are connecting to our library via Power Query instead of via the 'Export to Excel' option is because our library contains InfoPath forms that have repeating table data in the columns that we need to report on. Power Query   Is a free excel add-in available from Microsoft for both Excel 2010 Professional Plus & Excel 2013.  It is used when you need a way to transform data that isn't quite in the format you need. Step 1: Connecting to your SharePoint Library via Power Query. Open up Excel.  Click Power Query Tab > From Other Sources > From SharePoint List > Insert SharePoint Site URL Here's our first issue.  Only Lists are appearing in the Navigator.  Not to worry, Right-Click any of the Lists showing and click Edit to open up the Query Editor.   You should ...

I've recently been looking into a good Document Management solution using OOTB SharePoint 2010 functionality.  I'll explain my solution that should cover ISO in another post, but here I'd like to explain another issue I had with moving files from one Document Library to another while keeping all the version history. The only way I've found to keep all the version history is to make both libraries identical, then to open both libraries with File Explorer & move the files to the second Library.  Alternatively, you can use the 'Manage Content & Structure' area to move them as well. If you are like me, you have some trust issues with Microsoft at times, and don't want to risk moving the files and all their information if it doesn't work! So here's the easiest (oh god) way I found to do it safely. Export (Backup) a copy of the Document Library containing all the data you wish to transfer: Export-SPWeb -Identity "http://[servername]...