The Baretta

**UPDATE: This post is now outdated & I suggest using SharePoint Hub Sites to get Cross-Site Collection Navigation I will start by saying:   This solution sucks, but I've done my fair share of research/testing/swearing so you don't have to.  This is the best option you can currently achieve with OOTB (Out-of-the-box) functionality. Problem:  Many large companies moving to SharePoint Online have the same problem.  They have enough data that it needs to be spread out across multiple site collections.  How the data should be split up is a different story .  The fact is, they would like to have consistent Global Navigation across all site collections. Reasons why you would want the same global navigation across all site collections:  Visibility of everything that exists within the SharePoint Online Tenant Consistent navigation simplifies the User Experience, allowing them to be comfortable in any Site Collection without having to remember a ...

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 ...

PURPOSE Ever wondered what sort of SQL data connections are possible in SharePoint Online? Ever wondered of the limitations when trying this type of setup? If so, read on...  This tutorial will go over all the steps to setup everything from scratch.  Every step is important, you miss one, it won't work. WHAT YOU NEED SharePoint Online Plan 2 (you cannot achieve this with the basic version of SharePoint online as you require access to the Admin panel to setup Secure Store access permissions and BCS permissions. A windows azure account (which you can get a free 30 day trial as long as you're willing to provide your credit card. SharePoint Designer 2013 installed locally (required to create the final connection to the azure DB. Please note, you'll make this a hell of a lot easier if all these accounts are setup using the same office logon.  Otherwise you'll be logging in and out like a madman. IMPLEMENTATION Step 1 - Create SQL Database:   ...