No OFF for January 4, 2019

Happy new year! Doug and Todd are still wrapping up their break, but we’ll be back next week!

No OFF 12-28-2018 but get ready for group doc flow update

However if you want to add Yammer group governance plus all O365 group coverage (as opposed to just Teams) to the Documentation Flow I’ve been working on I do have some pre-work for you.

The flow I’ll publish next week does much more than just the Teams stuff, however it requires a Yammer API key for adding in state from that service which allows reporting on Yammer enablement as well as Teams.

Want to get started? Follow the instructions on this excellent blog post https://skodvinhvammen.wordpress.com/2018/04/20/governing-yammer-groups-using-microsoft-flow/ until you get to the part where you have the AuthZ code. You DO NOT need to make the referenced flow – my upcoming Git post will have one you can just import.

Happy New Year all!

Office Flash Friday Broadcast for December 21, 2018

Show Notes

Flow Updates for December
https://flow.microsoft.com/en-us/blog/december-2018-updates/

* New inputs for Flow buttons, can now do text yes/no, file, email, number, and dates.
* Flow button inputs can also be optional
* Less noise for Flow notification failures
* Improved help in Flow designer
* Flow APIs for management/governance
* New connectors

Power BI Premium Capacity Metrics App Update
https://powerbi.microsoft.com/en-us/blog/power-bi-premium-capacity-metrics-app-makes-navigating-and-viewing-metrics-at-workspace-level-easier/

* Shows report refresh time
* Support for cross-highlighting and aggregation for dataset and workspaces; makes it easier to understand workspace resource consumption.
* Query Waits are now bucketed

PowerApps Delivers New WYSIWYG Model-Driven Form Designer
https://powerapps.microsoft.com/en-us/blog/introducing-the-new-wysiwyg-model-driven-form-designer-public-preview/

* Live WYSIWYG preview
* Switch between different screen sizes
* Field searching/filtering
* Property updates are instantly reflected
* Save/Publish are now one button click

PowerApps Bar Code Scanner Update
https://powerapps.microsoft.com/en-us/blog/new-barcode-scanner-control/

* New control now relies on native device capabilities on iOS and Android
* Can use old control if you need bar code scanning in a web browser

Power BI Workspace Management in Admin Portal
https://powerbi.microsoft.com/en-us/blog/workspace-management-in-the-admin-portal/

Giving you a GUI option for what you could do in the Power BI Admin PowerShell
cmdlets.

PowerApps Canvas App Coding Standards and Guidelines
https://powerapps.microsoft.com/en-us/blog/powerapps-canvas-app-coding-standards-and-guidelines/

This whitepaper is designed to bring together information and best practices that might have already been available, but not necessarily in one place.

ONENOTE FOR WINDOWS CUSTOM TAGS
https://techcommunity.microsoft.com/t5/Office-365-Blog/Custom-tags-available-soon-in-OneNote/ba-p/302898

Mak’em, search’em, tag’em!

NEW – OFFICE APP FOR WIN 10
https://www.microsoft.com/en-us/microsoft-365/blog/2018/12/19/introducing-the-office-app-for-windows-10/

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/