Happy new year! Doug and Todd are still wrapping up their break, but we’ll be back next week!
Happy new year! Doug and Todd are still wrapping up their break, but we’ll be back next week!
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!
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/
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….
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!!
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
Just update!
Power BI Paginated Reports AMA Webcast
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
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
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
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
Increase for number of pages (now 30)
Power BI Export to PowerPoint GA
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
•
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/