Monthly Archives: November 2017

Office Flash Friday Episode for 2017-11-17

Show Notes

USING AZURE AND AI TO EXPLORE THE JFK FILES
https://blogs.technet.microsoft.com/machinelearning/2017/11/15/gain-insights-into-the-jfk-files-with-azure-search-and-cognitive-services/

Flow: New Connector Notifications

https://flow.microsoft.com/en-us/blog/new-flow-connector-notifications/

For those of you concerned about DLP and Flow, this is a must read!

Flow + Power BI: Data Driven Subscriptions!

http://angryanalyticsblog.azurewebsites.net/index.php/2017/11/13/data-driven-subscriptions-in-power-bi/

Need to deliver Power BI reports to a group of people in a context specific
manner? Check out this creative solution using subscription data married with
Flow and Power BI. Brought to you courtesy of Steve Howard (@AngryAnalytics).

PowerApps Announcements

https://powerapps.microsoft.com/en-us/blog/custom-form-launch/

* Custom SharePoint list forms with PowerApps
* Multi-select support for Choice, Lookup & People columns
* Read-only attachments support

AAD CONDITIONAL ACCESS – GA OF MAC SUPPORT + NEW FEATURES
https://cloudblogs.microsoft.com/enterprisemobility/2017/11/14/conditional-access-in-azure-ad-three-new-features-now-generally-available/

* Mac OSX support 10.11+ !!!
* AAD Conditional Access for iOS/Android in the Azure portal
* Devices blade in the Azure portal

MANAGE GOOGLE PLAY PROTECT W/INTUNE
https://cloudblogs.microsoft.com/enterprisemobility/2017/11/15/manage-google-play-protect-with-microsoft-intune/

More options for managed devices to prevent bad apps!

CLOUD APP SECURITY PROXY PUBLIC PREVIEW
https://cloudblogs.microsoft.com/enterprisemobility/2017/11/13/microsoft-cloud-app-security-proxy-is-now-in-public-preview/

* Combine AAD Conditional Access + Azure Info Protection + Cloud App Security
for granular rules!
* This one lets you do more RAdAC-style decisions around cloud app usage!!!
* GO READ IT!

COMPLIANCE MANAGER PUBLIC PREVIEW
https://blogs.office.com/en-us/2017/11/16/microsoft-365-helps-businesses-increase-trust-and-innovation-through-compliance-with-compliance-manager-preview/

* Check in out here:
* https://servicetrust.microsoft.com/ComplianceManager
* Reminder: Secure Score and the Considerations Workbook are “inside out” security views, and the Compliance Manager is an “outside in” lens; both are needed.

Office Flash Friday Episode for 2017-11-10

Show Notes

Resume Assistance Powered by LinkedIn

https://blogs.office.com/en-us/2017/11/08/bringing-ai-to-job-seekers-with-resume-assistant-in-word-powered-by-linkedin/

New ways to work in Project + Planner

https://blogs.office.com/en-us/2017/10/30/introducing-new-ways-to-work-in-microsoft-project/

Flow and OneDrive for Business

https://flow.microsoft.com/en-us/blog/microsoft-flow-integration-in-one-drive-for-business-and-new-connector-actions/

* Run a flow on demand for a selected file
* Run flows on a folder
* Convert file using path and Convert file (enabling you to convert files to
PDF)
* Create share link and Create share link by path
* Copy file and Copy file using path
* Upload a file from a URL
* Search for files in a folder
* Move or rename files

Flow and Planner, SharePoint, and… Flow!

https://flow.microsoft.com/en-us/blog/planner-triggers-connector-improvements/

* Planner

* When a new task is created
* When a task is assigned to me
* When a task is completed

* SharePoint Attachments

* Get and add

* Automate Flow

* Create, delete, permissions, etc.

Flow audit events now in Security and Compliance Center

https://flow.microsoft.com/en-us/blog/security-and-compliance-center/

Power BI Pro and Power BI Premium Blog

https://powerbi.microsoft.com/en-us/blog/power-bi-pro-power-bi-premium-flexibility-to-choose-the-licensing-best-for-you-and-your-organization/

A great overview of both licensing options and how to choose.

Power BI On-premises Data Gateway October Update

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

* Same data engine as October update of Power BI Desktop
* New features coming soon!

Power BI Desktop November Update

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

Highlights:

* Rule-based conditional formatting for table and matrix
* Lock objects on your report
* Report options for slow data sources
* Filtering performance improvements
* Add Column From Examples improvements

Power BI Single Sign-on for On-premises Data Sources

https://powerbi.microsoft.com/en-us/blog/announcing-single-sign-on-support-when-connecting-to-data-sources-from-the-power-bi-service/

* Need to update to latest gateway.
* Supported with DirectQuery connections only.
* Supported via Kerberos.
* Data sources currently supported: SQL Server, Teradata, SAP HANA
* Others coming later: Impala, Oracle, SAP BW, Spark

Power BI Report Server New Version

https://powerbi.microsoft.com/en-us/blog/new-version-of-power-bi-report-server-now-available/

* Contains all previously announced features from the August 2017 Preview
release (e.g. support for PBIX’s with imported data, Excel workbook support)
* Support for refresh of cached data sets
* Cached models now up to 2GB
* DirectQuery now supported (SQL Server, Azure SQL Database, Oracle, Teradata,
SAP HANA and SAP BW)
* REST API (navigate the folder hierarchy, discover the contents of a folder,
download a report definition, CRUD on objects: upload a report, execute a
refresh plan, delete a folder, etc.)
* Connect to SSRS shared datasets as OData
* Filter Power BI reports with URL parameters

Office Flash Friday Episode for 2017-11-03

Show Notes

POWER BI DEVELOPER OCTOBER UPDATE
https://powerbi.microsoft.com/en-us/blog/power-bi-developer-community-october-update/

* Power BI capacity based SKUs in Azure
* Q&A embedding!!!
* Filter updates (relative date filtering, include/exclude and “Top N” filter)

AZURE AD RESILIENCE FEATURES – ACTION REQUIRED!
https://cloudblogs.microsoft.com/enterprisemobility/

* Take note, federated AAD owners!

CONFIG MANAGER UPDATES 1710
https://cloudblogs.microsoft.com/enterprisemobility/2017/10/30/update-1710-for-configuration-manager-technical-preview-branch-available-now/

* Think hybrid

O365 OCTOBER RECAP
https://blogs.office.com/en-us/2017/10/31/new-to-office-365-in-october-online-tools-microsoft-ai-and-more/

* What happened!