Power BI Desktop Update & Ignite Session picks

This is episode 66 recorded on September 14th, 2018 where John & Jason talk to about the September release of Power BI Desktop and make picks for Microsoft Ignite 2018.

Show Notes:

Power BI Desktop – September 2018
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-september-2018-feature-summary/ 

Here’s the complete list of September updates:

Reporting

Analytics

Custom visuals

Data connectivity

Data preparation

Stuff to watch

Unlock petabyte-scale datasets in Azure with aggregations in Power BI
Scott Hanselman & Christian Wade
https://channel9.msdn.com/Shows/Azure-Friday/Unlock-petabyte-scale-datasets-in-Azure-with-aggregations-in-Power-BI

Ignite Sessions to highlight

GS007 – Microsoft PowerApps, Power BI, and Flow: Power platform vision and roadmap
Arun Ulagaratchagan,  Charles Lamanna,  Keith Whatling,  Richard Riley
https://myignite.techcommunity.microsoft.com/sessions/66664

BRK3107 – Microsoft Power BI Premium: Building enterprise-grade BI models for big data
Christian Wade,  Josh Caplan
https://myignite.microsoft.com/sessions/65442

BRK3108 – Microsoft Power BI: Enabling and governing self-service analytics
Adam Saxton,  Lukasz Pawloski
https://myignite.techcommunity.microsoft.com/sessions/65444

BRK2218 – Microsoft Power BI Desktop: Data exploration, analysis and storytelling
Amanda Cofsky,  Will Thompson
https://myignite.techcommunity.microsoft.com/sessions/65435

BRK2099 – Upgrade your social communities to knowledge-based communities
Dean Swann,  John White
https://myignite.techcommunity.microsoft.com/sessions/65625

Episode 64 – Microsoft Ignite Schedule Builder

This is episode 64 recorded on September 6th, 2018 where John & Jason talk about Microsoft Ignite and an alternative way to find sessions using Power BI.

This is episode 64 recorded on September 6th, 2018 where John & Jason talk about Microsoft Ignite and an alternative way to find sessions using Power BI.

 

Show Notes

Microsoft Ignite Schedule Builder

Power BI based Ignite session browser from tyGraph

tyGraph for Twitter tweet analysis for Microsoft Ignite

Episode 63 – Interview with Christian Wade

This is episode 63 recorded on August 30th, 2018 where John & Jason talk to Christian Wade, Senior Program Manager for Analysis Services at Microsoft, about Power BI in the Enterprise, the upcoming Manage Aggregations feature, and more.

Show notes

Capacity monitoring
https://powerbi.microsoft.com/en-us/blog/new-monitoring-capabilities-for-power-bi-premium-capacities/ 

Ignite session scheduler & Twitter

Ignite session scheduler & Twitter
https://link.tygraph.com/IgniteSessions
https://link.tygraph.com/IgniteTweets

Christian’s Talks at Business Application Summit

Building a data model to support 1 trillion rows of data and more with Microsoft Power BI Premium
https://www.microsoft.com/en-us/businessapplicationssummit/video/BAS2018-2172

Building Enterprise grade BI models with Microsoft Power BI Premium- https://www.microsoft.com/en-us/businessapplicationssummit/video/BAS2018-2115

Upcoming Events

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

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

SharePointFest Chicago
https://sharepointfest.com/Chicago/

SPTechCon Boston – February 10 – 13, 2019
https://www.sptechcon.com/west 

North American Collaboration Summit – March 14 – 16, 2019
http://www.collabsummit.org/

SPFest DC – April 29 – May 3, 2019
https://sharepointfest.com/Chicago/

SharePoint Conference 2019 – May 21 – 23, 2019
http://www.sharepointna.com

Eurpoean Collaboration Summit – May 27 – 29, 2019
http://www.collabsummit.eu

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/

Episode 48 – Power BI Desktop May Updates

This is episode 48 recorded on May 8th 2018… where John & Jason talk about Guy in a Cube’s new video, and walk through the new features of the May 2018 Power BI Desktop which includes the much anticipated incremental refresh.

Guy in a Cube CDSA – Common Data Service for Analytics (CDS-A) and Power BI – an Introduction
https://youtu.be/1vQ0HLNZ06A

Excel Gets custom visuals “soon”
https://powerbi.microsoft.com/en-us/blog/excel-announces-new-data-visualization-capabilities-with-power-bi-custom-visuals/

New PBI Desktop for May
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2018-feature-summary/

Reporting
• Conditional formatting by a different field
• Advanced slicer syncing
• Log axis improvements
• Data label options for funnel chart
• Set line stroke width to zero

Analytics
• Measure drillthrough

Power BI Premium
• Incremental refresh (preview)

Custom visuals
• Collage by CloudScope
• Chinese Color Map

Data connectivity
• New “From Web” connector – By example data extraction (preview)
• Common Data Service for Apps connector (beta)
• Azure KustoDB connector (beta)
• Google BigQuery and Azure HDInsight Spark connectors now generally available
• Adobe Analytics connector update – Support for multiple domain logins (preview)
• Visual Studio Team Services connector update – Analytics views support
• OLE DB connector update – Support for alternate Windows credentials
• SAP BW DirectQuery connector update – Improved technical name support

Data preparation
• Improvements to Add Column From Examples

Episode 47 – Excel Update with Olaf Hubel

This is episode 47 recorded on April 30th 2018… where John & Jason interview Olaf Hubel, Senior Program Manager at Microsoft on the Excel Engineering team.

Excel User Voice
https://excel.uservoice.com/

Excel Blog
https://techcommunity.microsoft.com/t5/Excel-Blog/bg-p/ExcelBlog

Excel Community
https://techcommunity.microsoft.com/t5/Excel/ct-p/Excel_Cat

Episode 46 – Community News and Updates

This is episode 46 recorded on April 17th 2018… where John & Jason talk about a whole bunch of miscellaneous items including GDPR, OneNote, Moving from SSRS SharePoint Integrated Mode, and SharePoint lists in Microsoft Teams.

GDPR White Paper
https://powerbi.microsoft.com/en-us/blog/power-bi-gdpr-whitepaper-is-now-available/
OneNote 2016 being deprecated
https://techcommunity.microsoft.com/t5/Office-365-Blog/The-best-version-of-OneNote-on-Windows/ba-p/183974
Eric Shupps post on issues converting from SSRS Integrated mode to Native mode
https://www.ericshupps.com/sharepoint-2016-ssrs-and-the-native-mode-report-viewer-web-part/
John’s blog series on working with complex SharePoint types in Power BI
https://whitepages.unlimitedviz.com

Jason’s 1 blog in the past couple of months… Viewing SharePoint lists in Microsoft Teams
http://www.sharepointlonghorn.com/using-sharepoint-lists-microsoft-teams/

Shameless self-promotion

SharePoint Conference North America
May 21-23, 2018
Use discount code WHITE for $50 off

European Collaboration Summit in Mainz, Germany
Use discount code ECS18-Trebinje for a 20 Euro discount
May 28-30, 2018