Monthly Archives: December 2017

See you next year!

Hello, Todd here. Doug and I are taking some time off and we’ll be back and ready to go in 2018! Merry Christmas and Happy New Year!

Office Flash Friday Episode for 2017-12-15

Show Notes

Power BI Desktop December Update

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

* Q&A for report creation
* Bookmarking updates (cross-highlighting, more control of what is bookmarked)
* Field properties, descriptions
* Updated scatter visual
* Map updated for high-density sampling based on lat/long
* New custom visuals (text filter, card browser, table heatmap, others)
* When drilling, other visuals become filtered
* Adobe Analytics connector
* HDInsight Interactive Query connector
* SAP BW connector improvements
* Netezza connector GA

Power BI Premium Larger Datasets

https://powerbi.microsoft.com/en-us/blog/announcing-power-bi-premium-support-for-larger-datasets/

* Dataset max was 1GB, now 10GB
* Check out the best practice guidance for large models

Power BI Bookmarking Contest

https://powerbi.microsoft.com/en-us/blog/bookmarking-contest-dec-12th-dec-27th/

* Runs through December 27th!
* Winners will be featured in a Power BI blog and win a Power BI Super Swag
Pack

Office 365 December Updates – Now with More AI!

https://blogs.office.com/en-us/2017/12/13/new-to-office-365-in-december-extending-human-ingenuity-with-everyday-ai/

* Automatic insights in Excel
* Unlock understanding of organizational lingo with Acronyms
* Cortana comes to Outlook and lets you know when to leave
* Automatic text extraction from images is indexed and searchable
* Check blog post for availability of these features

Office Flash Friday Episode for 2017-12-08

Show Notes

Power BI Service Updates

https://powerbi.microsoft.com/en-us/blog/power-bi-service-october-and-november-2017-feature-summary/

* Selective publish for Power BI Apps
* Other, previously disclosed updates

Power BI Developer Update for November

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

* Azure Capacity APIs for Embedded
* Extend report menus with custom options
* Preload Power BI assets for better user experience
* RLS works with Azure Analysis Services!

Flow Updates

https://flow.microsoft.com/en-us/blog/managed-metadata-tago/

… and …

https://flow.microsoft.com/en-us/blog/introducing-flow-launch-panel-in-sharepoint-lists-and-libraries/

* Flow now understands Managed Metadata in SharePoint!
* Append to arrays
* Mobile app improvements (iPhone X optimized, Button Flow improvements)
* Start a Flow from within SharePoint for selected item

Microsoft Whiteboard

https://blogs.office.com/en-us/2017/12/05/microsoft-whiteboard-preview-the-freeform-canvas-for-creative-collaboration/

Available on Windows 10, Surface Hubs

Office Flash Friday Episode for 2017-12-01

Show Notes

Power BI: Share Your Insights with External Guests with B2B Access

https://powerbi.microsoft.com/en-us/blog/power-bi-expands-access-to-intelligence-for-external-guest-users/

* Licensing can be done via Premium capacity or Pro licenses (you can provide or partner can bring their own license!)
* Check out the whitepaper linked to in the blog

Power BI: On-premises Data Gateway November Update

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

* Public preview of HA support!
* Enhanced logging – now includes mashup engine trace logs
* HTTPS fallback for connectivity resiliency
* As always… updated mashup engine.

FLOW: WORKING WITH DATES AND TIMES
https://flow.microsoft.com/en-us/blog/working-with-dates-and-times/

* Tips for dealing with dates as a first class citizen in Flow
* Converting time zones
* Doing date “math”

FLOW OF THE WEEK: PLANNER APPROVAL FLOW
https://flow.microsoft.com/en-us/blog/flow-of-the-week-planner-approval-flow/

* Use the Flow and Planner integrations to add approval processes to your projects

Office November Updates
https://support.office.com/en-us/article/What-s-new-in-Office-365-95c8d81d-08ba-42c1-914f-bca4603e1426?ui=en-US&rs=en-US&ad=US

* Check out the newness!

Teams: What’s New in November
https://techcommunity.microsoft.com/t5/Microsoft-Teams-Blog/What-s-new-in-Microsoft-Teams-November-update/ba-p/132962

* Manage Microsoft Teams via PowerShell
* Understand how your users are using Teams (user activity and app usage)
* Store your Teams data locally in the UK
* Support for conditional access on Macs
* New chat features (hide chats, leave a group chat)
* Improved settings and notifications (control who can post in General, rebuilt Settings UX, easily discover new tabs)
* Max team size is now 2,500 members
* New bots, tabs, and connectors

Now Easier to Reset Password on Azure AD-joined Devices
https://cloudblogs.microsoft.com/enterprisemobility/2017/11/20/resetting-passwords-on-azure-ad-joined-devices-is-much-easier-with-the-latest-windows-update/

* Greatly improved discoverability of password management options for AAD joined devices

Microsoft Advanced Threat Analytics: Detecting Remote Code Execution
https://cloudblogs.microsoft.com/enterprisemobility/2017/11/27/detecting-remote-code-execution-via-wmi-with-microsoft-advanced-threat-analytics/

* WMIC and Psexec security coolness!

OneDrive Secure Sharing Experience now GA
https://techcommunity.microsoft.com/t5/OneDrive-Blog/Introducing-a-new-secure-external-sharing-experience/bc-p/125925

* We talked about it – now it is GA!