Office Flash Friday Broadcast for 1/25/2019

Show Notes

EDU customers – Intune for Education update
https://techcommunity.microsoft.com/t5/Enterprise-Mobility-Security/Simplifying-device-management-for-schools-with-Microsoft-Intune/ba-p/324726

* Autopilot reset
* Better iOS support
* Assignment rename and dynamic grouping

M365 CIS Foundation Benchmark now available!
https://cloudblogs.microsoft.com/microsoftsecure/2019/01/10/best-practices-for-securely-using-microsoft-365-the-cis-microsoft-365-foundations-benchmark-now-available/

* Hot Off The Press from Jon Trull and the ECG team!
* CIS guide

Windows Defender ATP integration with Microsoft Information Protection
https://cloudblogs.microsoft.com/microsoftsecure/2019/01/17/windows-defender-atp-integrates-with-microsoft-information-protection-to-discover-protect-and-monitor-sensitive-data-on-windows-devices/

Dynamic content protection integration

O365 for Mac on the Mac App Store
https://www.microsoft.com/en-us/microsoft-365/blog/2019/01/24/office-365-for-mac-is-available-in-the-mac-app-store/

Get Office form the Mac store, and stay current!

Reminder: Cloud App Discovery – E3 vs E5 entitlement

* Discovery in MCAS (EMS E5) – The full blown Shadow IT Discovery solution. Documentation: https://docs.microsoft.com/en-us/cloud-app-security/set-up-cloud-discovery
* Discovery in AAD (EMS E3) – known as CAD. This is similar functionally to MCAS but does NOT include risk assessment and anomaly detection in discovered usage. Documentation: https://docs.microsoft.com/en-us/azure/active-directory/cloudappdiscovery-get-started
* You can review the comparison between Discovery in AAD CAD and MCAS here: https://docs.microsoft.com/en-us/cloud-app-security/editions-cloud-app-security-aad

Ignite BRK 2182 – Building Custom Connectors for PA/Flow
https://myignite.techcommunity.microsoft.com/sessions/65837#ignite-html-anchor

* Don’t be afraid – more config than code!
* Example: Yelp API exposure to PA/Flow!

Teams Bot Builder v4
https://techcommunity.microsoft.com/t5/Microsoft-Teams-Blog/Introducing-the-Preview-Release-of-Net-Teams-Bot-Builder-v4-SDK/ba-p/324571

* It is more capable, but the layer model can take some getting used to
* Get you Geek hat on and check it out

Introducing Teams Room
https://techcommunity.microsoft.com/t5/Microsoft-Teams-Blog/Introducing-Microsoft-Teams-Rooms/ba-p/323848

* SRS-style functions, grounded in Teams
* Proximity detection (coming soon), makes it easy to discover and add nearby, available Microsoft Teams Rooms to any meeting.
* Companion experiences with mobile, to join your devices in content-only mode.
* Support for dual screen rooms.

Updated guidance for upgrading from Skype for Business to Microsoft Teams
https://techcommunity.microsoft.com/t5/Microsoft-Teams-Blog/Updated-guidance-for-upgrading-from-Skype-for-Business-to/ba-p/324055

* A streamlined end-to-end approach, making it easier to navigate our proven success framework for implementing change
* A “Get started” FAQ to highlight quickly the value of upgrading to Teams as well as when and how to take the next step in your journey
* A sample upgrade timeline that takes you from the pre-upgrade phase where you will plan and prepare for your upgrade, through the upgrade and into the post-upgrade phase, designed to sustain and amplify your outcomes.
* A summary of key considerations when preparing to upgrade your tenant and users to Teams Only mode.
* Supplemental deep dive technical resources around coexistence, interoperability, and migration.

Power BI Service Personal Bookmarks
https://powerbi.microsoft.com/en-us/blog/announcing-personal-bookmarks-in-the-power-bi-service/

Create your own bookmarks to capture relevant views to you. Includes page, filters, slicers, visual selection state, sorting, drill state, item visibility.

No sharing yet, but coming soon!

Power BI Dataflows Updates for January 2019
https://powerbi.microsoft.com/en-us/blog/power-bi-dataflows-january-updates/

* 47 connectors supported at present! New: MySQL, Teradata, Azure Data Explorer, Active Directory, Smartsheet, Sybase… more supported behind the scenes (just not in the UI yet).
* Web connector now supports basic auth
* Support for native SQL queries (BYOS[QL])
* Advanced Power Query transformations via M.

Monetization of Power BI Custom Visuals
https://powerbi.microsoft.com/en-us/blog/new-monetization-option-for-power-bi-custom-visuals-through-appsource/

There are hundreds of visuals available in AppSource. Downloading is free, but some visuals may have in-app purchases for advanced features.

Power BI Report Server January 2019 Update
https://powerbi.microsoft.com/en-us/blog/power-bi-report-server-update-january-2019/

* Row-level security!
* Many new reporting features
* Improved DAX editor
* Accessibility improvements

Management of Data Gateways in the Power Platform Admin Center
https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-management-in-the-power-platform-admin-center/

Public preview.

PowerApps Audit Events now in Office 365 Security and Compliance Center
https://powerapps.microsoft.com/en-us/blog/microsoft-powerapps-audit-events-now-available-in-office-365-security-compliance-center/

Events: Created app, Edited app, Deleted app, Launched app, Published app, Marked app as hero, Market app as featured, Edited app permissions, Deleted app permission, Restored app version

Flow/PowerApps Connector Updates for January
https://flow.microsoft.com/en-us/blog/january-connector-improvements-and-new-releases/

* User assignment support for Planner connector – great use case for Flow!
* Get categories for Office 365 calendar events
* New connectors: Ally and TxtSync

Flow Word (Business) Connector
https://flow.microsoft.com/en-us/blog/generate-word-documents-in-your-flows/

* Generate PDFs from Word docs
* Populate a Microsoft Word template