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

* 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

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

Power BI Bookmarking Contest

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

Office 365 December Updates – Now with More 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

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

Power BI Developer Update for November

* 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

… and …

* 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

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

* 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

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


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


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

Office November Updates

* Check out the newness!

Teams: What’s New in November

* 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

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

Microsoft Advanced Threat Analytics: Detecting Remote Code Execution

* WMIC and Psexec security coolness!

OneDrive Secure Sharing Experience now GA

* We talked about it – now it is GA!