BIFocal

This is episode 14 recorded on September 8th, 2017 where John & Jason talk about Power BI Drill through Reports, Timeline Storyteller Visual, Microsoft Forms with Microsoft Flow and Power BI, and Microsoft Ignite.

Show Notes:

• Hurricane Relief
  • http://www.sharepointlonghorn.com/hurricane-harvey-and-the-sharepoint-community/
  • https://www.rebuildtx.org/
• Power BI Drillthrough Reports (Dustin Ryan)
  • https://sqldusty.com/category/power-bi/
• Timeline Storyteller Visual
  • https://powerbi.microsoft.com/en-us/blog/what-story-does-your-timeline-tell-introducing-the-timeline-storyteller-custom-visual-for-microsoft-power-bi/
• MS Forms, Flow and PowerBI
  • https://flow.microsoft.com/en-us/blog/forms-and-flow-and-powerbi/
  • Forms is a replacement for Excel surveys
  • Forms vs PowerApps and the stupid naming between the two
• Power BI lightbulb
  • Ed’s aha moment
  • SSRS using a report as a data source
  • Why would you want to do this?
• Ignite and Envision
  • Session browsers:
    • Ignite: http://bit.ly/Ignite17Sessions
    • Envision: http://bit.ly/Env17Sessions
  • Twitter Traffic:
    • Ignite: http://bit.ly/Ignite17Tweets
    • Envision: http://bit.ly/Envision17Tweets

This is episode 13 recorded on August 31st, 2017 where John & Jason talk about Power BI Embedded, Hurricane Harvey, and the new Power BI Report Server.

Show Notes:

• Hurricane Harvey
  • Katrina cost $100 Billion
  • Harvey estimated at $160 Billion
• Ted Pattison’s video on Power BI Embedded
  • Power BI Embedding Version 2 – The Full Story
• Power BI Report Server
  • PBIRS August Preview now available
    https://powerbi.microsoft.com/en-us/report-server/
  • PBI Desktop Optimized for PBI Report Server
    https://www.microsoft.com/en-us/download/details.aspx?id=55791
  • John’s blog post
    https://whitepages.unlimitedviz.com/2017/08/power-bi-report-server-completes-vision-onpremises-reporting/
• What is Power BI Report Server vs SSRS?
• How is/will be PBI Report Server licensed?
• How do we access the reports on a mobile?
• What about mobile reports, isn’t there some overlap? Datazen vs PBI?

I just blogged about the Hurricane Harvey relief effort that I have been working on for the past week. I know it isn’t about Business Intelligence, but if you have a moment please give it a read.

Hurricane Harvey and the SharePoint Community

While you are at it, if you have an extra minute to watch the following video (in the blog post as well) about an urgent need for the JCC of Houston I would be eternally grateful.

Best,
-jase

Recorded on August 23rd, 2017

This is episode 12 recorded on August 23rd, 2017 where we talk about the new SharePoint Communication Sites, OneDrive’s new sharing functionality, when times are not times, and the difference between embedding reports & Power BI Embedded.

Show notes:

• SharePoint Communication Sites and Power BI – a security nightmare? Where to put the report…..
  • Comm sites do not tie to an Office 365 Group, therefore no Power BI Workspace to publish to
  • Rollout complete: https://twitter.com/SharePoint/status/897189016470118400
• OneDrive new sharing functionality
  • Sharing from Explorer
    • Current version: Build 17.3.6963.0807
  • Hans Brender – https://hansbrender.com/onedrive-for-business-engl/
• Time zone fun
  • Date/Time/TimeZone renders differently
  • https://whitepages.unlimitedviz.com/2017/08/power-bi-time-values-browser-desktop/
• When is embedded not embedded
  • https://whitepages.unlimitedviz.com/2017/08/power-bi-embedded-embedding-power-bi-reports/
• EM1 & EM2 SKU availability
  • Only available on a yearly basis now except for E3
• ISV Accelerator program
  • https://info.microsoft.com/power-bi-embedded-accelerator-offer-register.html

Recorded on August 18th, 2017

This is episode 11 recorded on August 18th, 2017 where John & Jason talk about the News in Power BI including Desktop update, a new version of the onPrem Data Gateway & the Power BI Research panel.

• Web.Page requests require a gateway – What Gives?
• August Desktop update – https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2017-feature-summary/
  • Values as row headers: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2017-feature-summary/#valuesOnRows
  • PBI Source now GA: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2017-feature-summary/#liveConnect
  • “What If” sliders: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2017-feature-summary/#whatIf
• Corresponding Gateway as of today: https://powerbi.microsoft.com/en-us/blog/power-bi-on-premises-data-gateway-august-update/
• We know why the web part says preview
• Research Panel – Join today! – https://powerbi.microsoft.com/en-us/blog/join-the-power-bi-user-research-panel/
• Custom Connectors – Using https://community.powerbi.com/t5/Community-Blog/Power-BI-Custom-Connector-Youtube-Analytics/ba-p/211547

Recorded August 17th, 2017

This is episode 10 recorded on August 17th, 2017 where we talk about the new Power BI licensing model & Microsoft Ignite.

Show notes:

• The new licensing model & its implications
  • Old
    • Had different features & limitations (storage, refresh, sharing, and data access)
    • Free (but licensed)
      • Included sharing dashboard
        • Gave access to underlying Reports in read-only
    • Pro ($10 per user per month)

• New
  • Free (but licensed)
    • Author
  • Power BI Pro
    • Share & Collaborate
      • Build dashboards that deliver a 360-degree, real-time view of the business
      • Collaborate on share data

Audit and govern how data is accessed and used

• Package content and distribute to users with apps

• Power BI Premium
  • Scale large deployments
    • Distribute and embed content without purchasing per-user licenses
    • Publish reports on-premises with Power BI Report Server
    • Unlock more capacity and higher limits for your Pro users

• Power BI/Flow performance issues with the onPrem Data Gateway for TyGraph for Twitter’s Ignite tweets: http://bit.ly/Ignite17Tweets
• Session browser for Ignite: http://bit.ly/Ignite17Sessions