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
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
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: http://www.runasradio.com/Shows/Show/559
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
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
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 (
) blog post about migrating SSRS from one SharePoint farm to another @sharepointstacy
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.”
Support for Single Sign-On is available for the following data sources as of today:
Additional data sources will be added:
“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: https://github.com/SharePoint/sp-dev-solutions/tree/master/solutions/LinksAndHandlebarsTemplate
Dave’s blog: http://bostonmusicdave.com/
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.
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
Excel Based –
Office them to PBI theme converter –
“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>
This is episode 21 recorded at Microsoft Ignite on September 26th, 2017. This is the last of our Ignite interviews. We had the privilege of sitting down at length with Miguel Llopis, Senior Microsoft Program Manager responsible for Power Query, the On-Premises Data Gateway, and much more.
Miguel has been with Power BI since before there was a Power BI. Listen in – there’s a lot here!
This is episode 20 recorded on October 3rd, 2017 where John & Jason talk to John’s colleagues, Ed Senez & Dean Swann from tyGraph to debrief on Microsoft Ignite from a real world Business Intelligence perspective. We discuss tyGraph, which allows organizations to take Office 365 reporting to a whole new level, and finally about their new podcast, tyGraph Moneyball, which focuses in on the why of using reporting and analytics.
tyGraph YouTube channel
tyGraph Moneyball podcast
Dean’s Ignite session –
“Mining Yammer Data for Gold with Power BI”
This is episode 19 recorded on October 12th, 2017… where John & Jason talk to about the news including a new version & way of deploying Power BI Desktop and what’s interesting in the release of SQL Server 2017.
PBI Desktop now available in the Windows Store
The Modern client is there too
Settings get wiped out, but there’s a way to prevent that (John’s blog post)
Hard to find – Search for “Microsoft Power ….”
New Desktop this month
SSRS 2017 now generally available
SSAS 2017 now generally available
SSIS 2017 Now Generally available
Where is PowerPivot for SharePoint 2017????
This is episode 18 recorded at Microsoft Ignite on September 27th, 2017… where John & Jason talk to Anne Michels & Shilpi Sinha from the Office 365 Product Team about Office 365 Reporting.
Anne’s Ignite News post:
Office 365 Adoption Content Pack –> 22 reports
2 new usage reporting for Microsoft Teams released at Ignite
The Office 365 Adoption Content Pack in Power BI to go GA at the beginning of 2018 and will be rebranded to Office 365 Usage Analytics
Reports Reader Role
Available as of Sept 27th
Graph Reporting APIs go GA
SharePoint & OneDrive Admin Center updates
To get early access to the preview version of the new SharePoint admin center, please register at
Office 365 Usage Analytics will be GDPR compliant
Where to find info about Office 365 Reporting information online:
Office 365 Message Center:
Office 365 Roadmap:
Anne & Shilpi’s Ignite sessions
BRK2039: Understand how your users are using Office 365: Introducing Advanced usage reporting tools
Understand how your users are using Office 365: Introducing Advanced usage reporting tools
BRK2011: Understand how your users are using Office 365: What’s new in usage reporting
Understand how your users are using Office 365: What’s new in usage reporting – BRK2011
BRK1009: Manage Office 365 more effectively: What’s new in Office 365 administration
Manage Office 365 more effectively: What’s new in Office 365 administration – BRK1009
This is episode 17 recorded on September 26th, 2017 where John & Jason interview Chris Finlan, Program Manager on the SQL Server Reporting Services/Power BI Reporting Server team live at Ignite 2017, and talked at length about the announcements made at Ignite 2017, and about on-premises BI in general.
This interview was streamed live on Facebook, and can be seen below.
VIDEO Show Notes:
August 2017 Preview of Power BI Report Server
SQL Server Reporting Services 2017
Report Viewer Web Part for SSRS Native Mode