Episode 31 – Power BI Desktop January Update

This is episode 31 recorded on January 9th 2018… where John & Jason talk about the January features updates to Power BI Desktop, some things they noticed in the Desktop client, and some User Voice submissions.

 Reporting

Show and hide pages
Control data label background color for Cartesian and maps visuals
Increase area used for axis labels in charts
Bar/column padding control
Show dates as a hierarchy (preview)
Add an anchor date for relative date slicer
Top N selection in Q&A

Analytics

Correlation coefficient quick measure

Custom Visuals

PowerApps
TreeViz
Funnel with Source by MAQ Software
Box and Whisker chart by MAQ Software
Agility Planning Matrix Light
Image Grid
Gantt Chart by MAQ Software

Data connectivity

Support for Azure Active Directory authentication for Azure SQL Database & Data Warehouse connectors

Other

Advanced language settings for the Windows store app

Power BI Desktop things of note

-Help tab
-Windows Store download was behind the blog post

Previous Month’s Power BI Desktop update episode

Upcoming events

SharePointalooza\North American Collaboration Summit
March 2-3, 2018
SharePointFest DC
March 26-30, 2018
SharePoint Conference North America
May 21-23, 2018
Use discount code WHITE for $50 off
European Collaboration Summit in Mainz, Germany
May 28-30, 2018

Power BI User Voice submissions

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32871283-notification-after-updates-have-been-installed

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32871919-display-the-desktop-version

Episode 29 – 2018 Predictions from the Community

This is episode 29 recorded in December 2017… where John & Jason talk to community members about their 2018 predictions & make a few themselves.

A special thank you to Dan Holme for supporting us in this reimaging of his Penton series of Predictions. This was always a fun series of predictions to read, and we hope that you find this episode entertaining to listen to.

Thanks to everyone who contributed a prediction for 2018. Follow them on Twitter and check out their blogs below:

Andy Huneycutt – 5:15

https://twitter.com/AndyHuneycutt

Brian Alderman – 7:16

https://twitter.com/brianalderman
http://www.microtechpoint.com/

Christina Wheeler – 7:38

https://twitter.com/cwheeler76
https://www.sharepointwheeler.com/

Marc D Anderson – 8:20

https://twitter.com/sympmarc
http://sympmarc.com/

Chris McNulty – 9:45

https://twitter.com/cmcnulty2000

Dean Swann –  10:46

https://twitter.com/sdeanswann
https://www.tygraph.com/

Joanne Klein – 11:40

https://twitter.com/JoanneCKlein
https://joannecklein.com/

Jeremy Thake – 12:28

https://twitter.com/jthake
https://jeremythake.com

Susan Hanley –  12:57

https://twitter.com/susanhanley
http://www.susanhanley.com/

Mark Rackley – 13:10

https://twitter.com/mrackley
http://www.paitgroup.com/

Mike Fitzmaurice – 13:48

https://twitter.com/mikefitz
https://www.nintex.com/

Andrew Connell – 14:48

https://twitter.com/andrewconnell
http://www.andrewconnell.com/

Vlad Catrinescu – 15:48

https://twitter.com/vladcatrinescu
https://absolute-sharepoint.com/

David Broussard –  16:02

https://twitter.com/dbroussa
http://blogs.catapultsystems.com/author/dbroussard/

Richard Campbell – 17:10

https://twitter.com/richcampbell
http://runasradio.com/

 

We wish everyone a happy holiday season and a Happy 2018!

 

Episode 28 – December’s SQL Server & Power BI Desktop updates

This is episode 28 recorded on December 14th, 2017… where John & Jason talk about the new SQL Server Management Studio 17.4, a new open source SQL Server CLI, a change to Power BI Premium, and the December updates to Power BI Desktop.

iTunes ratings contest

We are actively trying to get our visibility up for the show and one way to accomplish that is through having ratings on iTunes. To that end, we are asking out listeners to take a moment and rate us on iTunes. Once we hit 10 reviews, hopefully before our Feburary 6th show, we are going to raffle off a $50 Amazon gift card to one of the people who rated us. You will need iTunes to be able to do it, but you can find our page here: https://itunes.apple.com/us/podcast/bifocal-clarifying-business-intelligence/id1266308225 

News

Upcoming events

  • Power BI Summit in Dublin – April 24-28 2018
    • Presented by PUG and Dynamic Communities

Related episodes:

Episode 24 – November’s Power BI Desktop update & more
Episode 15 – Microsoft Ignite 2017 Bonus Episode

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 http://www.schaeflein.net/blog, and is active on Twitter as @paulschaeflein. You can also reach him at paul@schaeflein.net.

Find out more about Paul at https://www.schaeflein.net/speaker-biography/

Helpful links:

The webinar for B2B (and Flow): https://www.youtube.com/watch?v=AIImcUZyP7U

SharePoint Conference NA: https://www.sharepointna.com use discount code SCHAEFLEIN

Power BI Report Server episode with Chris Finlan

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.

 

News

Guest Access now available

https://powerbi.microsoft.com/en-us/blog/power-bi-expands-access-to-intelligence-for-external-guest-users/

  • 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: https://whitepages.unlimitedviz.com/2017/11/facebook-location-tracking-power-bi/

 

Community shout outs

DigiCert: https://www.digicert.com/

Pluralsight: https://www.pluralsight.com/

RunAs Radio: http://www.runasradio.com/Shows/Show/559

Richard Campbell: https://twitter.com/RichCampbell

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