Episode 82 – 2018 Power BI Wrap Up

This is episode 82 recorded on December 18th, 2018 where John & Jason talk about the highlights of 2018 in the Power BI space & make some predictions for 2019.

Show Notes

Favorite features list:

Show/Hide pages (Jan)
Desktop in the Windows store (Feb)
Slicer sync (Feb)
Persistent filters (March)
Report page tooltips (March)
Bookmarking (March)
Action/Bookmark buttons (April)
Q&A Explorer (April)
Incremental Refresh (May)
New “From Web” Connector (May)
Composite models (July)
SharePoint Roadmap – July
New workspace experience (August)
Monitoring app for Premium (August)
Printing (August)
Aggregations (September)
New Power BI Home (September)
M Intellisense (September)
DAX Editor (October)
Dataflows (November)
New modelling view (November)
Paginated reports (November)
Copy/Paste between Desktop Files (Nov)
Smart guides (Dec)
External Dataflows (December)

Episode 81 – Interview with Andrew Connell

This is episode 81 recorded live at SharePointFest Chicago on December 6th, 2018 where Jason talks Andrew Connell, co-host of the Microsoft Cloud Show and Instructor & Entrepreneur at Voitanos.io, about Azure AppInsights & developing for proper analytics.

Show Notes

Andrew Connell is a full-stack web developer and 12-time annual recipient of the Microsoft MVP Award for Office Development, Office Servers and Services with a deep developer background in SharePoint, Office 365, and Microsoft Azure. He has spoken at various conferences around the world including Microsoft’s TechEd, BuildIgnite & SharePoint conferences, Angular’s ngConfAngularUSPTechConSP Live360 among many others. He’s taught hundreds of people via in-person & online classroom based training for over 10 years including through the training company Critical Path Training he co-founded & co-operated for four years (2009-2013). Additionally, he has a catalog of on-demand video-based training available through Pluralsight. Microsoft has hired Andrew multiple times to present at internal conferences such as TechReady, develop, deliver and publish training courses and to serve as a key strategic and technical advisor to multiple internal product teams.

Over the years Andrew has proven himself time & time again as an experienced technical trainer and course author. Building on this vast experience, he is excited to bring it direct to you to provide the ideal learning experience.

Voitanos is where you’ll find Andrew’s self-hosted video-based on-demand technical training courses and educational resources.

The Microsoft Cloud Show

The only place to stay up to date on everything going on in the Microsoft Intelligent Cloud world including Azure and Office 365. 

Whether you are new to the cloud, old hat or just starting to consider what the cloud can do for you this podcast is the place to find all the latest and greatest news and information on what’s going on in the cloud universe.  Join long-time Microsoft aficionados and SharePoint experts Andrew Connell and Chris Johnson as they dissect the noise and distill it down, read between the lines and offer expert opinion on what is really going on.  Just the information … no marketing … no BS, just two dudes telling you how they see it.

Ep 80 – December 2018 Power BI Desktop Update

This is episode 80 recorded on December 17th, 2018 where John & Jason talk about last update to Power BI Desktop in 2018 including features like Smart guides for aligning objects on a page & the preview of Live connect support for Q&A.

Show Notes

Reporting

Analytics

Modeling

Custom visuals

Data connectivity

Data preparation

Other

Useful links

November 2018 Power BI Desktop Update

Episode 77 – Interview with Arun Ulag

Thisis episode 77 recorded on November 21st, 2018 where John & Jason talk aboutsome new blogs posts from John and interview Arun Ulag, General Manager ofPower BI Engineering at Microsoft, about all things Power BI at MicrosoftIgnite on September 25th, 2018.

Show Notes

About Arun
https://www.linkedin.com/in/arun-ulag-086b576/

John’s blog posts

USE POWER BI DATAFLOWS TO WAREHOUSE SHAREPOINT LIST DATA

GET THE MOST OUT OF POWER QUERY IN POWER BI DATAFLOWS

Have a question you want answered? Drop us a note or send us a .WAV file of your question at info@bifocal.show and we will answer your question on the show in our end of year wrap up show.

Episode 75 – PASS Summit News & Dataflows

Thisis episode 75 recorded on November 9th, 2018 where John & Jason talk aboutthe news coming out of PASS Summit and break down the introduction of Dataflows.

Show Notes

Power BI delivers dataflows, enterprise reporting, and major updates to Power BI Desktop

https://powerbi.microsoft.com/en-us/blog/power-bi-delivers-dataflows-enterprise-reporting-and-major-updates-to-power-bi-desktop/

  • Dataflows expand self-service data prep in Power BI
  • SQL Server Reporting Services technology now in Power BI
  • Power BI Desktop November Update
    • Will cover in detail on a future show once this drops

Introducing: Power BI data prep with dataflows

https://powerbi.microsoft.com/en-us/blog/introducing-power-bi-data-prep-wtih-dataflows/

  • Self-service data prep for big data in Power BI 
  • Advanced Analytics and AI with Azure
  • Support for the Common Data Model
    • Getting started with self-service data prep
    • Ingesting large amounts of data with Incremental Refresh
    • Building complex ETL projects with Linked entities
  • Gaining further insights with Computed entities
    • Connecting datasets to your data

Public Preview of Paginated Reports in Power BI Premium Now Available

https://powerbi.microsoft.com/en-us/blog/public-preview-of-paginated-reports-in-power-bi-premium-now-available

Power BI Paginated Reports also available in Power BI Mobile Apps(preview)

https://powerbi.microsoft.com/en-us/blog/power-bi-paginated-reports-also-available-in-power-bi-mobile-apps-preview

Paginated report metrics and dataflow metrics now available in Premium Capacity Metrics app

https://powerbi.microsoft.com/en-us/blog/paginated-report-metrics-and-dataflow-metrics-now-available-in-premium-capacity-metrics-app/

Premium Capacity Metrics app – query metrics histogram now available

https://powerbi.microsoft.com/en-us/blog/premium-capacity-metrics-app-query-metrics-histogram-now-available/

 

Episode 73 – Interview with Chris Finlan

This is episode 73 recorded on October 22nd, 2018 where John & Jason talk to Chris Finlan, Senior Program Manager for Power BI at Microsoft, about the Power BI Report Server, Paginated Report in the cloud via Power BI, and much more.

Show Notes

Power BI Report Server release timing update

Chris Finlan on Twitter

PASS Summit (Focus Groups)

Episode 61 – App Workspaces and Content Packs with Lukasz Pawlowski

This is episode 61 recorded on August 9th, 2018 where John & Jason talk to Lukasz Pawlowski, Senior Program Manager on the Power BI team at Microsoft, and mention highlights from the August Power BI Desktop release.

This is episode 61 recorded on August 9th, 2018 where John & Jason talk to Lukasz Pawlowski, Senior Program Manager on the Power BI team about the coming changes to Content Packs and App Workspaces, and mention highlights from the August Power BI Desktop release.

Content Packs and Group connected Power BI workspaces have been with us since the launch of the new Power BI in 2015. Both of these features are about to go some significant changes. Lukasz Pawlowski is the program manager for both features, and he joins us to explain what they are and why they are happening, among other things.

In addition, we also have a quick look at the August 2018 release of Power BI Desktop.

Show Notes:

Enable you team with new workspace experiences (preview) 

Power BI Desktop August 2018 Feature Summary

Episode 60 – SharePoint Business Intelligence – The End of an Era

This is episode 60 recorded on August 7th, 2018 where John & Jason talk about a new initiative for Power BI Beginners & the deprecation and removal of BI Features in SharePoint 2019.

Show Notes:

Business Intelligence in SharePoint 2019

What’s deprecated or removed from SharePoint Server 2019 Public Preview

Self-service BI and enterprise reporting on-premises with Power BI Report Server 

Upcoming webinar – Building a KPI Scorecard with Custom Visuals in Power BI with Reid Havens

 

Episode 57 – Business Application Summit 2018 Recap

This is episode 57 recorded on July 23rd, 2018 where John & Jason recap the announcements at the 2018 Business Application Summit in Seattle, Washington.


Show Notes:

The Digital Feedback Loop

All about machine learning

Nothing is new – until now with data and predictions

Demos of CRM, Talent, Integration of LinkedIn Reporter

Remote Assist with AR and CRM data

Future of Modern and Enterprise BI

3 focus areas

  • Unified Platform for  both self-service & enterprise BI
  • Intuitive experiences
  • Pervasive AI for BI

July Desktop Release – for another show…….

Enterprise

  • Performance enhancements – 1.5 trillion rows, .25 PB of data was instant
    • Aggregation feature – aggregations caching
    • Showing direct connect to Spark
  • Composite Models – multiple direct query
  • SSRS – first see in August
  • Multi Geo
  • ALM – ALM Toolkit for Power BI from MAQ
  • Data Flows is the final name for Data Pools – magic is open data lake storage direct connected.

Usability

  • Fit and finish in Power BI Desktop. Now relationship editor, Design guides, visuals to the top
  • PRINTING – PDF.
  • Select on data to filter out
  • OOB Themes
  • Expression Based properties – even text properties like SSRS
  • Pivot tables
  • Commenting

AI

  • Quick insights gets a big improvement
  • Q&A within reports. “Explain the increase” with Quick insights.

Episode 56 – Developer & Gateway news and MVP Renewals

This is episode 56 recorded on July 12th 2018 where John & Jason talk about Microsoft Research Open Data, Developer & Gateway news, Power BI Desktop vs Service, and MVP renewals.

Notes:

Jason & John got renewed as Office Servers & Services MVP! John is now a double MVP in Data Platform for Power BI. Then Microsoft changed the categories again and they are Office Apps & Services MVPs now… either way, we are BACK!

MSR Open Data

https://www.microsoft.com/en-us/research/blog/announcing-microsoft-research-open-data-datasets-by-microsoft-research-now-available-in-the-cloud/

Power BI Desktop vs Power BI Service

https://www.mssqltips.com/sqlservertip/4139/compare-power-bi-desktop-vs-power-bi-online/

Power BI Developer community June update

https://powerbi.microsoft.com/en-us/blog/power-bi-developer-community-june-update/

On-premises data gateway June update is now available

https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-june-update-is-now-available/

Power BI Workspace Collections is being deprecated – was supposed to happen June 30… get out now!!!! Get on Power BI Embedded

End of Microsoft Fiscal, 4th of July, O’Canada Day, and the looming Business Application Summit all lead to slow news time.

Coming events

Business Applications Summit 7/22-7/24 – https://www.microsoft.com/en-us/businessapplicationssummit

SPSNYC 7/28 – http://www.spsevents.org/city/nyc

SPFest Seattle 8/20-8/24 – https://sharepointfest.com/Seattle/

SPTechCon 8/26-8/29 – http://www.sptechcon.com/

Microsoft Ignite 9/24-9/28 – https://www.microsoft.com/en-us/ignite

European SharePoint Conference 11/26-11/29 – https://www.sharepointeurope.com/