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 55 – The Power of the Cloud

This is episode 55 recorded on June 28th 2018 where John & Jason talk about a few recent bugs and service interruptions, the recent Power of the Cloud conference, PowerApps, Flow, and some recent improvements to the usability of the On Premises Data Gateway

 

Show Notes

Organizational Account Authentication has stopped working for Microsoft Graph in Power BI
https://community.powerbi.com/t5/Issues/Error-getting-OData-from-Microsoft-Graph-Access-to-the-resource/

Easier configuration of Gateway data sets in the Power BI service:
https://powerbi.microsoft.com/en-us/blog/easier-set-up-of-datasets-in-power-bi/

Power of the Cloud show –
http://powerofthecloud.net

IWMentor PowerApps training
https://www.iwmentor.com/courses/powerapps-introduction

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/

Thrive Conference  Dec 4-5 2018 – http://www.thriveconf.com

Ep 54 – Miscellaneous news & the looming Power BI Embedded deadline

This is episode 54 recorded on June 21th 2018… where John & Jason talk about mobile app configuration of PBIRS settings, a new way of analyzing Excel in Power BI, and the upcoming Power BI Embedded deadline.

Show Notes

Report Server configuration with MDM/EMM tools

https://powerbi.microsoft.com/en-us/blog/drill-through-and-report-server-configuration-with-mdm-tools/

 

Analyze in Power BI coming to the SharePoint UI – Kerem Yuceturk

https://techcommunity.microsoft.com/t5/SharePoint-BI/New-feature-Create-Power-BI-reports-from-tables-in-Excel-files/td-p/201843

 

Use Outlook to organize Power BI reports – Chris Finlan

https://christopherfinlan.com/2018/06/11/use-outlook-shortcuts-to-organize-your-favorite-power-bi-reports-and-dashboards/

 

Business Application Summit – Sessions are up

https://www.microsoft.com/en-us/businessapplicationssummit

 

Power BI Embedded deadline is coming up!

https://www.bifocal.show/2018/03/27/episode-42-the-power-bi-embedded-show/

Megan Assarane interview

 

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 53 – New initiatives

This is episode 53 recorded on June 13th 2018… where John & Jason talk about new initiatives in their world, discussed MyAnalytics, Azure Machine Learning, and some of the Power BI Service limits & what to do about them.

 

Jason – working on:

  • New product launch
  • Changes in my role
    • Microsoft Inspire & Ready
    • Partnerships
    • A renewed focus on process
      • Leads to more Power BI
      • Newly on E5
        • MyAnalytics
  • Summer plans

 

John – working on:

  • Azure ML and ML Studio – why does this stuff matter? The predictive part of BI
  • The PBIX Grow up story. Hitting the limits of the service.
  • tyGraph
    • For SP, OneDrive and Teams
  • New stuff based on CDSA
  • Power of the Cloud – June 22 – https://powerofthecloud.net/

 

Upcoming events

           TSPUG 6/20 – https://www.meetup.com/TorontoSPUG/

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/

 

The Intrazone: Episode 6 “The Desktop Diet”

https://techcommunity.microsoft.com/t5/Microsoft-SharePoint-Blog/The-Intrazone-episode-6-The-desktop-diet/ba-p/203323

Episode 52 – Power BI Desktop June update

This is episode 52 recorded on June 7th 2018… where John & Jason talk about the new Power BI Desktop update & the role of Power BI Desktop.

Power BI Desktop June Update

Reporting

Custom Visuals

Modeling

Data Connectivity

Other

 

Previous Power BI Desktop Update – May

Episode 51 – Power BI news & updates

This is episode 51 recorded on June 7th 2018… where John & Jason talk about news in the Power BI space, the Power BI Developer community update for May, and some twitter shenanigans.

 

News & Updates

Power BI Developer community May update

Episode 50 – Live from SPC18 in Las Vegas

This is episode 50 recorded live on May 21st 2018… where John & Jason talk the announcements & other things happening at the SharePoint Conference North America in Las Vegas.

Facebook Live show: https://www.facebook.com/bifocalshow/videos/255860991644964/ 

Notes:

  • Power BI Insights baked into lists
  • Was that a modern BDC built in?
  • 3D editor site of course
  • SP2019 – still waiting on deprecation statements for PP and PP4SP
  • Our tutorial…. What were people looking for?

Episode 49 – SPCNA session picks with Liz Sundet

This is episode 49 recorded on May 15th 2018… where John & Jason talk to Liz Sundet, Office Servers & Services MVP from Minnesota, about the upcoming SPCNA Conference in Las Vegas next week and some news related to the upcoming GDPR deadline.

Liz Sundet

Liz is a Microsoft Office Servers and Services MVP and is involved with multiple areas of the business as a consultant for SharePoint and Office 365. Her work includes a variety of aspects from developing strategies to aid in collaboration, identifying best practices for SharePoint and Office 365 to run efficiently and working with multiple teams on identifying needs and areas of improvement. Liz loves a challenge, so everything from a business problem to troubleshooting an error in a system is just another learning opportunity. As a trainer and international speaker, she hopes to inspire others to learn something they can apply to their own work immediately. When she is not working in SharePoint or traveling, you may find her in a variety of activities as diverse as she is: playing music, riding motorcycles, training her dog and even a craft or two. You can follow her on twitter @percusn

Liz’s Picks

Three Must Have SharePoint Workflows with Microsoft Flow Level – Vlad Catrinescu
https://www.sharepointna.com/#!/session/Three%20Must-Have%20SharePoint%20Workflows%20with%20Microsoft%20Flow
5 Simple Ways to Improve Business Productivity with SharePoint, OneDrive, and Microsoft Flow Level: 100 Stephanie Donahue
https://www.sharepointna.com/#!/session/5%20Simple%20ways%20to%20improve%20business%20productivity%20with%20SharePoint,%20OneDrive,%20and%20Microsoft%20Flow
Take a Chance and Hire that  Fine Arts Major Liz Sundet
https://www.sharepointna.com/#!/session/Take%20a%20Chance%20and%20Hire%20that%20Fine%20Arts%20Major

John’s Picks

SharePoint Server 2019: A First Look – Bill Baer & Hani Loza
https://www.sharepointna.com/#!/session/SharePoint%20Server%202019:%20A%20First%20Look
Get the Facts from your SharePoint Site with Analytics, Then Improve It! – Liz Sundet
https://www.sharepointna.com/#!/session/Get%20the%20Facts%20from%20your%20SharePoint%20Site%20with%20Analytics,%20Then%20Improve%20It!
Understanding Office 365 Usage Reporting – Scott Hoag
https://www.sharepointna.com/#!/session/Understanding%20Office%20365%20Usage%20Reporting

Jason’s Picks

Keynote – SharePoint and OneDrive connect your workplace – Jeff Teper, Seth Patton, Omar Shahine, Dan Holme
https://aka.ms/watch/SPVS
Be a SPFx Ninja: with these Performance, Debugging, Logging and Telemetry Tricks! – Andrew Connell
https://www.sharepointna.com/#!/session/Be%20a%20SPFx%20Ninja:%20with%20these%20Performance,%20Debugging,%20Logging%20and%20Telemetry%20Tricks!
Developing SharePoint Framework Web Parts with Power BI Embedding – Ted Pattison
https://www.sharepointna.com/#!/session/Developing%20SharePoint%20Framework%20Web%20Parts%20with%20Power%20BI%20Embedding
Using Flow and Azure Functions to Customize your Site Design – Dave Feldman
https://www.sharepointna.com/#!/session/Using%20Flow%20and%20Azure%20Functions%20to%20Customize%20your%20Site%20Design
Mastering Modern Authentication and Authorization for SharePoint and Office 365 Applications – Eric Shupps
https://www.sharepointna.com/#!/session/Mastering%20Modern%20Authentication%20and%20Authorization%20for%20SharePoint%20and%20Office%20365%20Applications

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