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

https://powerbi.microsoft.com/en-us/blog/new-version-of-power-bi-report-server-now-available/

PowerApps Custom Visual

PowerApp on a report, not just a tile

PowerApp visual can be filtered

Another post about licensing

https://powerbi.microsoft.com/en-us/blog/power-bi-pro-power-bi-premium-flexibility-to-choose-the-licensing-best-for-you-and-your-organization/

PBI Report Theme Generators

Online – https://powerbi.tips/tools/report-theme-generator-v3/

Excel Based – https://hopeinternational.box.com/s/gd57sn7djq0bs6p2miut62extxdgucwn

Office them to PBI theme converter – https://1drv.ms/u/s!AkRyAgtzGndznMl3VKm1K8YJp0wsHQ

“Everything you wanted to know” Workshops

John speaking at ESPC

  • https://www.sharepointeurope.com/events/everything-wanted-know-power-bi-afraid-ask/

SPFest Chicago (use code WHITE for a discount)

  • http://www.sharepointfest.com/Chicago/index.php/sessions/workshops

SPFest DC (use code WHITE for a discount)

  • http://www.sharepointfest.com/DC/index.php/sessions/46-workshops/monday-workshops/148-ws-107-everything-you-wanted-to-know-about-power-bi-but-were-afraid-to-ask

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

  • http://www.sharepointna.com

Episode 21 – Miguel Llopis, PM for On-Prem Data Gateway and Power Query

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!

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”

Episode 19 – Dummy proofing for Executives

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.

Show Notes:

Episode 18 – Office 365 Reporting with Anne & Shilpi

John White & Jason Himmelstein talk about Office 365 Reporting with Anne Michels & Shlipi SinhaThis 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.

Show Notes:

Anne’s Ignite News post:

https://techcommunity.microsoft.com/t5/Office-365-Blog/What-s-new-in-Office-365-Usage-Reporting-Ignite-Edition/ba-p/109157

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

Preview post: https://blogs.office.com/en-us/2017/03/31/whats-new-in-office-365-administration-public-preview-of-microsoft-graph-reporting-apis/


Other topics:

SharePoint & OneDrive Admin Center updates

To get early access to the preview version of the new SharePoint admin center, please register at https://aka.ms/joinAdminPreview

Office 365 Usage Analytics will be GDPR compliant

Where to find info about Office 365 Reporting information online:

Office 365 Message Center: https://portal.office.com/adminportal/home#/MessageCenter

Tech Community: https://techcommunity.microsoft.com/t5/Office-365-Blog/bg-p/Office365Blog

Office 365 Roadmap: https://www.office365.com/roadmap

Support Center: https://support.office.com/en-us/article/Activity-Reports-in-the-Office-365-admin-center-0d6dfb17-8582-4172-a9a9-aed798150263


Anne & Shilpi’s Ignite sessions

BRK2039: Understand how your users are using Office 365: Introducing Advanced usage reporting tools

Via MyIgnite: https://myignite.microsoft.com/sessions/53327

YoutTube: 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

Via MyIgnite: https://myignite.microsoft.com/sessions/53258

YoutTube: 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

Via MyIgnite: https://myignite.microsoft.com/sessions/53331

YouTube: Manage Office 365 more effectively: What’s new in Office 365 administration – BRK1009

Episode 17 – Live from Ignite with Chris Finlan

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.

Show Notes:

August 2017 Preview of Power BI Report Server

SQL Server Reporting Services 2017

Report Viewer Web Part for SSRS Native Mode