Listener contribution ask for 2018 Prediction episode

As we close in on the end of 2017 and we decided to do something a bit different with our final episode of the year, episode 29. We are calling it our 2018 Prediction episode. While we were in Chicago two weeks ago we recorded an interview with Paul Schaeflein and also grabbed some interviews with friends from the SharePoint Community and asked them one question: “What is your prediction for 2018?”. It was so much fun that we decided that we should open this up to our listeners to contribute answer to as well.

This is an open ended question that we are not looking to be targeted to Business Intelligence, even though our show is about BI, but instead a more general fun question that we will string together for a fun episode. Our preference is to have this be tech related, however the only off limits topics are politics & religion. We aren’t looking to stir the pot, just have some fun, possibly thought provoking chats.

If you would like to contribute your 2018 prediction please upload a .wav, .mp3, .mp4 or any other video/audio format to We will only be using the audio from the file so feel free to make funny faces at us. We are looking to keep each prediction to under 2 minutes, and be sure to tell us & the other listeners who you are!

I also recorded a video about this that you can watch below:

We want to thank Dan Holme for permission to rip of an old idea of his and turn it into a fun end of year episode. When Dan used to write for Penton a few years ago he put out a blog post of predictions for the coming year. Personally, I’ve missed reading that post and we all thought it would make for some fun listening.

FYI, we are going to close submissions for this on December 23rd, 2017 that way our awesome audio engineer can work his magic and not have to work for us on Christmas.


Episode 27 – A chat with Paul Schaeflein on Power BI & Microsoft Teams

This is episode 27 recorded on December 6th, 2017 from SharePointFest Chicago… where John & Jason talk to Paul Schaeflein about helping people transform applications using Microsoft Teams, authentication stuff using Azure B2B & Paul quizzes us on how people should be using Power BI.

Paul Schaeflein is a solution architect/developer with more than three decades experience in architecting, designing and developing software solutions. This experience covers a vast range of technologies, languages and industries. Paul is an independent consultant, helping organizations of all sizes with their application development, ALM and SharePoint/Office 365 projects. Paul is a top-rated speaker, having presented at SharePoint Evolutions, the Microsoft SharePoint Conference and TechEd conferences, as well as user groups. In recognition of these community efforts, he is recognized as a Most Valuable Professional (MVP). Paul has a blog at, and is active on Twitter as @paulschaeflein. You can also reach him at

Find out more about Paul at

Helpful links:

The webinar for B2B (and Flow):

SharePoint Conference NA: use discount code SCHAEFLEIN

Power BI Report Server episode with Chris Finlan

Episode 26 – OnPrem Data Gateway & Power BI Developers news

This is episode 26 recorded on December 6th, 2017 from SharePointFest Chicago… where John & Jason talk about the latest updates to the OnPrem Data Gateway, the technical reference implementation for enterprise BI and reporting, and the latest news for Power BI Developers.


Technical reference implementation for enterprise BI and reporting

On-premises data gateway November update is now available

  •     The public preview of the long-awaited High Availability support.
  •     The “Additional Logging” setting of the gateway will now include the Mashup engine traces.
  •     The gateway will now automatically fall back to communicating through Azure Service Bus using HTTPS if direct TCP fails.
  •     The gateway now includes the November version of the Mashup engine.

Power BI Developer community November update

Azure Resource Manager API

  • Scale up/ down
  • Pause/ start resource
  • Create/ Delete resource
  • Get capacity information
  • Update capacity
  • Get capacity list in a resource group/ subscription

….they will add support for ARM PowerShell soon

Cloud Service Provider purchase channel now available

Visual Options menu and Context menu extension

Injecting custom actions into the options & context menus

Preload API for a better loading experience

Update connection string

RLS support on AS Azure for pre-defined roles

API 1.9 is now available, adding the ability to open the default browser and navigate to a URL

How to clone workspaces using the API

Microsoft’s best practices for building custom visuals in Power BI

Episode 25 – Power BI Guest Access

This is episode 25 recorded on November 24th, 2017… Black Friday… or as we call it, Analytics Friday… where John & Jason talk about Power BI Guest Access using Azure B2B and some tips, tricks & community shout outs.



Guest Access now available

  • AAD B2B with Power BI is available starting today.  Read the documentation and try inviting an external user now!
  • For more information and a step-by-step guide to distributing BI content with Power BI and Azure AD B2B read this whitepaper. Also visit Azure documentation for more information on Azure AD B2B.


-Power Query Tip – Cached data remembers its source – even after you change it in the Query Editor. You need to make sure it’s totally refreshed.

-Facebook Query has totally changed:


Community shout outs



RunAs Radio:

Richard Campbell:

Episode 24 – November’s Power BI Desktop update & more

This is episode 24 recorded on November 17th, 2017… where John & Jason talk to about the latest Power BI Desktop update, some new custom visuals, and some community contribution picks.

Power BI Desktop November Feature Summary

Stuff John is excited about in November’s Power BI Desktop

  • Rule based conditional formatting in tables
  • Cell alignment for tables
  • Visual ordering in the selection pane (z-order)
  • Lock report objects !!!!!!!
  • ESRI Plus subscription available….
  • Report options for slow data sources in Direct Query (good, but….)
  • New visuals – Image timeline, Social graph, Venn diagram, HTML viewer

Here’s the complete list of November updates:



Data connectivity – Single Sign-on

Impala connector – support for Windows Authentication
check out Episode 23 for more on SSO

Query editing

Add Column From Examples improvements

Community forum stuff:

Cool infographic that shows what is what in the Power BI space (features w/ license requirements)


Power BI Desktop terminology & definitions

New Office 365 launcher showed up

Flow – Calculate running totals

Stacy Simpkins (@sharepointstacy) blog post about migrating SSRS from one SharePoint farm to another


Episode 23 – Interview with Dave Feldman

This is episode 23 recorded on November 7th, 2017… where John & Jason talk to about the new single-sign on methods for the Power BI service and an interview with Dave Feldman, Microsoft MVP from Shire Pharmaceuticals.

Blog post by Miguel Llopis: Announcing Single Sign-On Support when connecting to data sources from the Power BI Service

“… it is now possible to use Single Sign-On, leveraging Kerberos, when connecting to certain data sources using DirectQuery mode from Power BI.”

Config link:

Support for Single Sign-On is available for the following data sources as of today:

    • SQL Server
    • Teradata
    • SAP HANA

Additional data sources will be added:

EOY 2017

    • Impala
    • Oracle
    • SAP BW

H1 2018

    • Spark
    • And others…

Interview notes:
“Using BI to make intelligent business decisions”TyGraph, HyperFish & onPrem IIS Logs to do proper analysis around what was being used during the planning phases of the integration between Shire & BaxaltaThe analysis fueled Dave’s migration decisionsLooking into the future to multi-geo decision planning for SharePoint Online

Shire’s Hub and Link Web Parts:
Dave’s blog:

Episode 22 – Power BI Report Server release news

This is episode 22 recorded on November 2nd, 2017… where John & Jason talk to about the brand new release of Power BI Report Server, PowerApps custom visuals, & Power BI Licensing.

Show Notes:

Power BI Report Server new version

PowerApps Custom Visual

PowerApp on a report, not just a tile

PowerApp visual can be filtered

Another post about licensing

PBI Report Theme Generators

Online –

Excel Based –

Office them to PBI theme converter –!AkRyAgtzGndznMl3VKm1K8YJp0wsHQ

“Everything you wanted to know” Workshops

John speaking at ESPC


SPFest Chicago (use code WHITE for a discount)


SPFest DC (use code WHITE for a discount)


SharePoint Conference North America (use code JASEHIMM for a discount)< /p>