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

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-2017-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:

Reporting

Analytics

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.

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!