The Baretta

If you need to export a list of staff from an Active Directory Group, follow these steps.  Allows you to gather all the names & usernames of staff in a particular group and save the information into Excel. Step By Step How To: Open up Excel > Power Query Tab Click From Other Sources > From Active Directory: (In Excel 2016 this is found under: Data Tab > New Query > From Other Sources > From Active Directory) screenshots from Excel 2016 on left, Excel 2010 w/ Power Query Add-on right A popup will ask you to enter your domain name.  It should already be populated with the correct information but if not, input your companies domain name & Click OK: In the Navigator that opens up, expand your domain tree and double click group: You should now see a list of all groups in Active Directory in the Power Query Editor: In order to find & filter for a specific Group, Click the Down-Arrow for the 'distinguishedName' column > T

I'm presuming you've seen the god-like feature set of Power BI.  I reckon you've probably even opened up browser edition and had a quick play.  Then you've come to the realisation that yeah it is just as awesome as that presenter advised!   But how does it fit together with the rest of the Office 365 suite, and why are there so many different ways to use it!? Here's a quick historical view of the product and a brief introduction into the pros/cons of each option to help you choose a path based on what your business requirements are.  Truth is, you'll probably want all options available to you, however each new solution might require a certain platform. If you take ANYTHING away from this post, remember there are three ways you can use the Power BI suite:  Excel Add-Ins, Power BI Online App, Power BI Desktop App... Excel Power BI Suite (PowerPivot, PowerQuery, PowerMap, PowerView) Before Power BI became an entity of its own, it was initially birthed as

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 now see a screen s

Most people can't find the 'Export to Spreadsheet' option from the Action drop-down menu due to not being on the Overview.aspx page. But if you've modified the Overview page via SharePoint Designer, then you've probably lost the Overview menu completely The solution is to create a New List View via SharePoint Designer and set it as Default (crucial!). Done. If you don't set the new view as the default page, then the Export option will still be missing.

Have you recently upgraded to SharePoint 2013 but can't seem to open excel or word docs inside a Document Library? Are you getting a URL that starts something like this? ms-word:nft|u|  ms-excel:ofv|u| Chances are it's because you have both Office 2010 installed on your computer as well as either the full Office 2013 suite or any single Office 2013 product (Here's looking at you SharePoint Designer 2013!!!). The reason for this is related to the new Microsoft SharePoint Foundation Support feature that gets updated when you install an Office 2013 product, in turn updating a few pointers to look at the Office15 Hive folder. Others have solved this issue before me, but to save you having to read lots of comments, the solution is to install Office 2010 SP2 . Here's some links to a few blogs that helped me realise the cause and find the solution. http://blogs.technet.com/b/projectsupport/archive/2013/04/04/sharepoint-2013-problems-opening-documents-with-of