Office Flash Friday Broadcast for December 7, 2018

Show Notes

Power BI Helper Webcast
https://powerbi.microsoft.com/en-us/blog/webinar-12-4-power-bi-helper-a-free-community-tool-for-developers-by-reza-rad/

Power BI Helper is a community developed tool to assist with documentation, model clean up, and simply understanding what’s going on in a PBIX file. Tune in on 12/4 to hear more.

Power BI Ask a Question in Detail
https://powerbi.microsoft.com/en-us/blog/qna-december-2018-update/

A more detailed overview of how you can interrogate Power BI data with natural
language.

Power BI Quarterly Survey
https://powerbi.microsoft.com/en-us/blog/help-improve-power-bi-quarterly-survey/

Security Graph Hackathon Kickoff
https://cloudblogs.microsoft.com/microsoftsecure/2018/12/03/kicking-off-the-microsoft-graph-security-hackathon/

$15K in prizes, enter before 3/1/2019.

Flow Tab in Teams and Other Integration
https://flow.microsoft.com/en-us/blog/introducing-the-flow-tab-in-teams-and-new-teams-triggers/

* New Flow Tab for teams
* Flow triggers for new Teams messages and mentions

OUTLOOK MOBILE – NEW UX
https://www.microsoft.com/en-us/microsoft-365/blog/2018/12/05/power-and-simplicity-new-outlook-mobile-design-helps-you-get-things-done-faster/

* Cleaner design
* Overall better use/navigation

HYBRID: OFFICE ONLINE SERVER NOV 2018 UPDATES
https://techcommunity.microsoft.com/t5/Office-365-Blog/Office-Online-Server-November-2018-Update/ba-p/292500

* Many updates/improvements
* Compat w/adv PPT features, better O365 alignment

POWERPOINT CAPTIONING – UPDATE
https://www.microsoft.com/en-us/microsoft-365/blog/2018/12/03/present-more-inclusively-with-live-captions-and-subtitles-in-powerpoint/

* We’ve show it before, but work the recap!
* Enterprise customers – Make sure you understand data flow for compliancy

ICYMI: SPO PROVISIONING SERVICE
https://provisioning.sharepointpnp.com/

* Interesting resources for SPO – very dev-centric, but good
* Example – Cool potential end user self-service update to Modern; check it out
* Reminder SP Dev weekly –
https://developer.microsoft.com/en-us/office/blogs/sharepoint-dev-weekly-episode-16/

EDGE HEADING TO CHROMIUM ENGINE
https://blogs.windows.com/windowsexperience/2018/12/06/microsoft-edge-making-the-web-better-through-more-open-source-collaboration/#Bsk3hhIE6qGUTAP5.97

Let’s consider that shift….

OFF Broadcast for November 30, 2018

Show Notes

From Doug – Sample Teams/Group Doc Flow!

http://aka.ms/dougcode or http://bit.ly/dougcode

* Time for some DougCode
* My Mn SharePoint Saturday flow session is up on Git
* Sample to connect to Graph and document Office Groups with Teams, Channels
and Tabe
* TEST FIRST!!

To-Dos in Word
https://www.microsoft.com/en-us/microsoft-365/blog/2018/11/07/collaborate-with-others-and-keep-track-of-to-dos-with-new-ai-features-in-word/

Collaboratively create content with your team with a natural workflow.

MCAS ADDS REAL-TIME CONTROLS TO APP PROXY!
https://techcommunity.microsoft.com/t5/Enterprise-Mobility-Security/MCAS-brings-its-real-time-CASB-controls-to-on-prem-apps/ba-p/286269

* By 2020 on-premises workloads will still account for 27%
* The apps still need real-time protection, and now (uniquely!) MCAS offers it!

AZURE ATP LATERAL MOVEMENT PATH DETECTION
https://techcommunity.microsoft.com/t5/Enterprise-Mobility-Security/Reduce-your-potential-attack-surface-using-Azure-ATP-Lateral/ba-p/291787

Avail for each user prof and computer

GUIDANCE: A ROADMAP APPROACH TO SECURING PRIV. ACCTS
https://techcommunity.microsoft.com/t5/Enterprise-Mobility-Security/Reduce-your-potential-attack-surface-using-Azure-ATP-Lateral/ba-p/291787

Check out the outlined approach courtesy of Mark Simos and MS ECG!

WINDOWS DEFENDER ATP RISK SCORE INTEGRATION W/COND ACCESS RISK SCORE!
https://cloudblogs.microsoft.com/microsoftsecure/2018/11/28/windows-defender-atp-device-risk-score-exposes-new-cyberattack-drives-conditional-access-to-protect-networks/

Read thru the scenario; awesome integration

NOVEMBER WINDOWS DEFENDER ATP UPDATES
https://cloudblogs.microsoft.com/microsoftsecure/2018/11/15/whats-new-in-windows-defender-atp/

* Attack surface reduction rules
* Moving from alerts > incidents

TEAMS MANAGEMENT AND AUTOMATION
https://techcommunity.microsoft.com/t5/Microsoft-Teams-Blog/New-Provide-a-great-Teams-experience-with-improved-manageability/ba-p/288059

* Admin roles released
* Graph APIs released!!!

TEAMS ADOPTION HUB
https://techcommunity.microsoft.com/t5/Microsoft-Teams-Blog/NEW-Teams-Adoption-Hub-Enhanced-guidance-for-user-adoption/ba-p/291580

* Start, Experiment and Scale approaches
* Includes our popular Day in the Life training one sheets, an overall service
adoption project plan, example personas and helpdesk guidance to name a few

O365 CHAMPIONS PROGRAM
https://www.microsoft.com/en-us/microsoft-365/success/champions?rtc=1

Check it out if you haven’t!

SHAREPOINT CUSTOMIZATIONS UPDATE
https://www.microsoft.com/en-us/microsoft-365/blog/2018/11/26/take-your-microsoft-365-investments-further-with-sharepoint-customizations/

* Teams tabs as SP Web Parts
* Continual new feature updates
* If you haven’t already – CHECK OUT THE NEW SP FRAMEWORK!!

M365 – NEW IN NOVEMBER!
https://www.microsoft.com/en-us/microsoft-365/blog/2018/11/29/new-to-microsoft-365-in-november-tools-to-keep-you-in-your-workflow-and-fine-tune-content/

* Lots of new stuff – ToDo, AI and more
* FIDO Sign On!
https://www.microsoft.com/en-us/microsoft-365/blog/2018/11/20/sign-in-to-your-microsoft-account-without-a-password-using-windows-hello-or-a-security-key/

Power BI On-premises Gateway November Update

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

Just update!

Power BI Paginated Reports AMA Webcast

https://powerbi.microsoft.com/en-us/blog/webinar-11-27-meet-and-ask-the-microsoft-report-server-team-anything/

Available on demand now!

Flow Online Conference Coming Up

https://flow.microsoft.com/en-us/blog/microsoft-flow-conference-2018-2/

12/12/2018! Mark your calendars!

Flow Rich Text Editing and New Connectors

https://flow.microsoft.com/en-us/blog/rich-text-editing/

* Check out new rich text editor in the “Send an email (V2)” action in the
Office 365 and Outlook.com connectors.
* New connectors include: Imprezian360, Encodian, Soft1, Zahara

OFF 2018-11-16

Show Notes

PowerApps Improved Discoverability with Microsoft Search
https://powerapps.microsoft.com/en-us/blog/make-powerapps-discovery-easier-with-microsoft-search-in-bing/

PowerApps and Flows ALM with Solutions
https://powerapps.microsoft.com/en-us/blog/apps-and-flows-lifecycle-management-just-got-easier/
https://powerapps.microsoft.com/en-us/blog/solutions-in-powerapps/
https://flow.microsoft.com/en-us/blog/solutions-in-microsoft-flow/

Use solutions to manage multiple PowerApps Canvas apps and Flows as a single,
well, solution.

PowerApps Display Names in Canvas Apps (Preview)
https://powerapps.microsoft.com/en-us/blog/display-names-enters-preview-for-canvas-apps/

No more T-shirt Size becoming T_x002d_shirt_x0020_size.

Power BI Desktop November 2018 Update
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-2018-feature-summary/

* Expand/collapse matrix row headers
* Copy/paste between PBIX files
* Updated filtering experience with styling and more control over what report
consumers see
* More accessibility enhancements – selection pane is fully accessible!
* Updates to colors with conditional formatting on some visuals
* Related questions for Q&A for conversational analysis
* New modeling view – also includes enhanced accessibility
* Deeper dive on new modeling view:
https://powerbi.microsoft.com/en-us/blog/modeling-view-in-power-bi-desktop/
* Composite models now GA
* New/updated DAX functions: ISINSCOPE, NONVISUAL, ROLLUPADDISSUBTOTAL
* New custom visuals
* New Azure DevOps Server connector
* PDF connector now supports Start and End Page parameters
* Updated Azure Consumption Insights connectors to include budget and reserved
instances data

Power BI Premium Preview of Paginated Reports (SSRS reports)
https://powerbi.microsoft.com/en-us/blog/public-preview-of-paginated-reports-in-power-bi-premium-now-available/

What you’d expect: highly formatted, pixel-perfect reports, export to popular
formats (Word, PDF, etc.), printing, parameters, sharing.

What’s coming: scheduling and email subscriptions, embedding, authoring against
already created Power BI datasets, drill through from a Power BI report to a
paginated report.

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

Just wow!

Power BI Dataflows in Preview
https://powerbi.microsoft.com/en-us/blog/introducing-power-bi-data-prep-wtih-dataflows/

ETL comes to Power BI as a first class citizen. Leveraging Azure Data Lake Store
and the Common Data Model.

Power BI Premium Metrics App Updated for Dataflows and Paginated Reports
https://powerbi.microsoft.com/en-us/blog/paginated-report-metrics-and-dataflow-metrics-now-available-in-premium-capacity-metrics-app/

More Metrics App updates here:
https://powerbi.microsoft.com/en-us/blog/premium-capacity-metrics-app-query-metrics-histogram-now-available/

Power BI AI Announcements
https://powerbi.microsoft.com/en-us/blog/power-bi-announces-new-ai-capabilities/

* Azure Cognitive Services capabilities available in Power BI (text analytics,
image analytics)
* Key driver feature (why does something happen?)
* Build ML models using automated machine learning
* Integrate with advanced ML models managed by Azure ML

No OFF for 11/9

Doug is vacationing and Todd is customering so there will be no OFF show for Friday, 11/9. We’ll see you next week!

-Doug and Todd

OFF 2018-11-02

Show Notes

BOOM! O365 HITRUST CERT!!!!
https://techcommunity.microsoft.com/t5/Healthcare-and-Life-Sciences/Office-365-Earns-HITRUST-CSF-Certification/ba-p/267545

And another cert falls…

M365 OCTOBER UPDATES
https://www.microsoft.com/en-us/microsoft-365/blog/2018/10/31/new-to-microsoft-365-in-october-tools-to-create-impactful-content-and-help-transition-to-the-cloud/

Office goodness

HAVE A 2010-LOOKING INTRANET?? TIME FOR A NEW LOOK!
https://techcommunity.microsoft.com/t5/Microsoft-SharePoint-Blog/New-resource-center-page-to-help-build-your-modern-intranet-on/ba-p/280633

Read up and brand up, or get displaced by other tools!!

SP SERVER 2019 GA!!!
https://techcommunity.microsoft.com/t5/Microsoft-SharePoint-Blog/Announcing-General-Availability-of-SharePoint-Server-2019/ba-p/272546

* Hybrid cloud lives!!
* Also releases – SfB 2019, EX 2019

NET M365 SP ADMIN CENTER PREVIEW
https://techcommunity.microsoft.com/t5/Microsoft-SharePoint-Blog/Unleash-your-SharePoint-admin-superpowers-with-new-admin-center/ba-p/270075

INTUNE DEVICE-BASED SUBSCRIPTION OPTION
https://techcommunity.microsoft.com/t5/Enterprise-Mobility-Security/Microsoft-Intune-announces-device-based-subscription-for-shared/ba-p/280817

One more choice to support device-centric us cases

WIN DEFENDER – SANDBOX EXECUTION
https://cloudblogs.microsoft.com/microsoftsecure/2018/10/26/windows-defender-antivirus-can-now-run-in-a-sandbox/

Important security improvement

MCAS AND OAUTH THREAT PREVENTION
https://techcommunity.microsoft.com/t5/Enterprise-Mobility-Security/Managing-risky-3rd-party-app-permissions-with-Microsoft-s-CASB/ba-p/276401

Approaches to detect and remediate oAuth permission grants across services.

Flow Repair Tips, South America Availability

https://flow.microsoft.com/en-us/blog/repair-tips-south-america/

Flow Analytics in Power Admin Portal

https://flow.microsoft.com/en-us/blog/power-platform-analytics-connectors/

Flow Online Conference

https://flow.microsoft.com/en-us/blog/microsoft-flow-conference-2018/

December 12, 9am-1:30pm MST

Flow Portal Navigation and Designer Updates

https://flow.microsoft.com/en-us/blog/new-flow-navigation-actions/

Power BI Gateway Update for October

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

* Support for Vertica and Web by Example Connectors
* Public preview of SAP HANA Single Sign-On (SAML) Support
* Public preview of SAP BW Single Sign-On (Kerberos) Support
* Improved diagnostic logging
* Updated mashup engine

Power BI New Regions

https://powerbi.microsoft.com/en-us/blog/new-power-bi-regions-in-india-australia-united-states/

* Central India
* Australia East
* Central US (Iowa)

Power BI GA of Custom and Certified Connectors

https://powerbi.microsoft.com/en-us/blog/announcing-general-availability-of-custom-and-certified-connectors-for-power-bi/

Increase for number of pages (now 30)

Power BI Export to PowerPoint GA

https://powerbi.microsoft.com/en-us/blog/export-to-powerpoint-is-now-generally-available-and-looking-ahead-at-what-s-coming-next/

No OFF 2018-10-26

No show this week, but check out these:

MCAS and oAuth threat prevention
https://techcommunity.microsoft.com/t5/Enterprise-Mobility-Security/Managing-risky-3rd-party-app-permissions-with-Microsoft-s-CASB/ba-p/276401

• Approaches to detect and remediate oAuth permission grants across services.

iCYMI: Yammer Ip range shift > move to DNS firewall rules!
https://techcommunity.microsoft.com/t5/Yammer-Blog/Using-hard-coded-IP-addresses-for-Yammer-is-not-recommended/ba-p/276592

OFF 2018-10-19

Show Notes

Power BI Desktop October 2018 Update

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-october-2018-feature-summary/

* Added searching in filter cards
* Improved accessibility for editing charts and Q&A
* ArcGIS performance improvements
* Much improved DAX editor!
* Composite models and Aggregations support in the service
* Explain the increase/decrease for non-additive measures
* Web by Example connector is now GA
* SAP BW v2 connector is now GA
* SAP BW Message Server connector is now GA
* Vertica connector is now GA
* Dynamics NAV and Dynamics 365 Central connectors are now GA
* Dynamics 365 Central on-premises connector in preview
* Data profiling in Query Editor
* Fuzzy matching in Query Editor
* Control data export from reports

Aggregations now available in Power BI Service Preview

https://powerbi.microsoft.com/en-us/blog/aggregations-for-petabyte-scale-bi-available-in-the-power-bi-service/

Power BI Report Server Release Timing Update

https://powerbi.microsoft.com/en-us/blog/power-bi-report-server-release-timing-update/

Starting in 2019, Report Server and its associated Power BI Desktop will release
in January, May, and September.

Upcoming Web Cast on Power BI Data Flows

https://powerbi.microsoft.com/en-us/blog/webinar-10-23-advanced-data-prep-with-power-bi-dataflows-for-unified-data-and-powerful-insights/

PowerApps How-To Video Series

https://powerapps.microsoft.com/en-us/blog/how-to-videos/

Azure AD Federation Patterns

https://blogs.msdn.microsoft.com/mrochon/2018/09/04/federation-patterns-using-azure-ad/

OFF 2018-10-12

Show Notes

Power BI Developer September 2018 Roundup

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

* Capacity Monitoring App for Power BI Embedded in Azure
* Advanced filtering via URL parameters
* Update connections between cloud and on-prem data sources programmatically
* USERNAME() now supports ASCII characters for a better RLS experience
* Beta of custom visuals supporting TypeScript 3.0.1 and more

Power BI Deep Dive into Custom Visuals

https://powerbi.microsoft.com/en-us/blog/deep-dive-in-the-organizational-custom-visuals/

If you are leveraging organizational custom visuals, or want to, make sure to
check out this post.

PowerApps and Flow Sessions Not to Miss from Ignite

https://powerapps.microsoft.com/en-us/blog/ignite-2018/

More weekend watching content!

PowerApps Enhancements to Make Creating New Apps Easier

https://powerapps.microsoft.com/en-us/blog/newpahomepage/

These enhancements are designed to make development of new apps more
straightforward for creators.

New Updates Coming to Office in October

https://www.microsoft.com/en-us/microsoft-365/blog/2018/10/02/new-inking-and-3d-updates-bring-presentation-design-to-the-next-level-this-and-more-coming-to-office-in-october/

* Use ink to create intelligent presentations in PowerPoint with Ink to Text
and Design Ideas
* New integration with To-Do and Outlook.com
* Use ink to manage tasks in To-Do
* Forms is now available to consumers in Public Preview!

Enhanced Integration Between PowerApps and Dynamics

https://powerapps.microsoft.com/en-us/blog/nocdspackage/

Previously it was required to install a package to achieve proper integration
between a Common Data Service database and Dynamics. This integration is now
built-in which provides a more seamless and reliable experience.

Public Preview of Win32 App Distribution via Intune

https://techcommunity.microsoft.com/t5/Enterprise-Mobility-Security/Sneak-peek-Public-preview-of-Win32-application-deployment-using/ba-p/264460

PowerApps Admin Analytics

https://powerapps.microsoft.com/en-us/blog/powerapps-admin-analytics-get-an-enterprise-wide-view-2/

NO OFF 2018-10-05

We’re doing studio maintenance this week, so no show today. Click here to check out the Ignite supershow from last week if you missed it!

 

OFF – AFN Ignite Supershow 2018 -09-28

To watch the episode Click Here

Show covered the Ignite Book Of News (at least what we could fit into 90+ min… https://news.microsoft.com/uploads/prod/sites/507/2018/09/IGNITEBOOKOFNEWS.pdf