Episode 47 – Excel Update with Olaf Hubel

This is episode 47 recorded on April 30th 2018… where John & Jason interview Olaf Hubel, Senior Program Manager at Microsoft on the Excel Engineering team.

Excel User Voice
https://excel.uservoice.com/

Excel Blog
https://techcommunity.microsoft.com/t5/Excel-Blog/bg-p/ExcelBlog

Excel Community
https://techcommunity.microsoft.com/t5/Excel/ct-p/Excel_Cat

Episode 46 – Community News and Updates

This is episode 46 recorded on April 17th 2018… where John & Jason talk about a whole bunch of miscellaneous items including GDPR, OneNote, Moving from SSRS SharePoint Integrated Mode, and SharePoint lists in Microsoft Teams.

GDPR White Paper
https://powerbi.microsoft.com/en-us/blog/power-bi-gdpr-whitepaper-is-now-available/
OneNote 2016 being deprecated
https://techcommunity.microsoft.com/t5/Office-365-Blog/The-best-version-of-OneNote-on-Windows/ba-p/183974
Eric Shupps post on issues converting from SSRS Integrated mode to Native mode
https://www.ericshupps.com/sharepoint-2016-ssrs-and-the-native-mode-report-viewer-web-part/
John’s blog series on working with complex SharePoint types in Power BI
https://whitepages.unlimitedviz.com

Jason’s 1 blog in the past couple of months… Viewing SharePoint lists in Microsoft Teams
http://www.sharepointlonghorn.com/using-sharepoint-lists-microsoft-teams/

Shameless self-promotion

SharePoint Conference North America
May 21-23, 2018
Use discount code WHITE for $50 off

European Collaboration Summit in Mainz, Germany
Use discount code ECS18-Trebinje for a 20 Euro discount
May 28-30, 2018

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.

News:
Blog post by Miguel Llopis: Announcing Single Sign-On Support when connecting to data sources from the Power BI Service
https://powerbi.microsoft.com/en-us/blog/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: https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-kerberos-for-sso-pbi-to-on-premises-data/

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

Links:
Shire’s Hub and Link Web Parts: https://github.com/SharePoint/sp-dev-solutions/tree/master/solutions/LinksAndHandlebarsTemplate
Dave’s blog: http://bostonmusicdave.com/
Hyperfish: https://www.hyperfish.com/
tyGraph: https://www.tygraph.com/

Episode 20 – Ignite recap and Office 365 Reporting with the tyGraph Team

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.

Show Notes:

tyGraph

tyGraph YouTube channel

tyGraph Moneyball podcast

Dean’s Ignite session – “Mining Yammer Data for Gold with Power BI”