The Baretta

What  Had an issue in the last few days (approx 30/08/2018) where a Excel Report & a Power BI Report was failing to refresh.  The reports were pulling data from a SharePoint Online List. Here's the error I was getting Error: The column 'Activities' of the table wasn't found Why When I built these reports, I used Power Query to import the SharePoint List Data & then to make the data easier to look at, I removed all the System Columns that I didn't need to see.  One of these System Columns was called 'Activities'. Anyway, I'm not sure why, but for some reason when I now get data from SharePoint Lists, the 'Activities' column no longer exists, so the refresh was breaking because it couldn't remove a column I wasn't even using! How to fix I just opened up the advanced editor, found the line where I was removing columns, and deleted the reference to "Activities". Done! let     Source = SharePoint.Tables(

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