Category Archives: Uncategorized

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….

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

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/

OFF – AFN Ignite Supershow 2018 -09-28

To watch the episode Click Here

Show covered the Ignite Book Of News (at least what we could fit into 90+ min… https://news.microsoft.com/uploads/prod/sites/507/2018/09/IGNITEBOOKOFNEWS.pdf 

OFF 2018-09-21

To watch the episode, Click Here

Help Shape the Future of Power BI

https://powerbi.microsoft.com/en-us/blog/shape-the-future-of-power-bi-join-our-user-research-panel/

We’re making it easy to participate in research studies to review planned updates to Power BI.

Power BI Dashboard Comments

https://powerbi.microsoft.com/en-us/blog/announcing-dashboard-comments-in-power-bi/

  • Comments for dashboards or specific visuals
  • @ mentioning
  • Works in mobile as well as desktop/web

Power BI Desktop September 2018 Update

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

  • Reporting: create dot plots using scatter chart visual, copy value/selection from table/matrix, built-in report themes, report page tooltip GA & card support, accessibility improvements for analytics/formatting panes
  • Analytics: preview of aggregation (huge!), Q&A support for row-level security
  • Custom visuals: horizon chart, etc.
  • Data connectivity: PDF connector preview, SAP BW support for measure properties, Dataflows preview
  • Data prep: M intellisense!, columns from example support for padding

On-premises Data Gateway September 2018 Update

http://www.microsoft.com

Mashup engine matches that of the Power BI Desktop September 2018 update, bug fixes, etc.

Web Client of Remote Desktop now GA for Windows Server 2016/2019 Preview

https://techcommunity.microsoft.com/t5/Enterprise-Mobility-Security/Remote-Desktop-web-client-now-generally-available/ba-p/250588

Using PowerApps to Power Microsoft HR Employee Interaction

https://powerapps.microsoft.com/en-us/blog/microsoft-thrive/

New PowerApps Screen Templates for Office 365

http://www.microsoft.com

Screens for: email, people, meetings, calendars, first-time tutorial, success screen

Office VBA + AMSI: Parting the veil on malicious macros

https://cloudblogs.microsoft.com/microsoftsecure/2018/09/12/office-vba-amsi-parting-the-veil-on-malicious-macros/

  • Read up on it!

IMPORTANT – Modern Desktop Announcement – Review from 9/6

https://www.microsoft.com/en-us/microsoft-365/blog/2018/09/06/helping-customers-shift-to-a-modern-desktop/

  • Tools for getting and staying current
    • System Center/Intune
    • Office Readiness
    • Windows Analytics

Ignite: O365 Network/Multi-Geo content and settings

https://techcommunity.microsoft.com/t5/Office-365-Blog/Multi-Geo-and-Networking-sessions-at-Ignite-2018/ba-p/252880

Ignite: Teams Session Awesomness!

https://techcommunity.microsoft.com/t5/Microsoft-Teams-Blog/Unleash-productivity-with-these-Microsoft-Teams-breakout/ba-p/251318

  • If you are going, or if you watch later, check these topics out!

No OFF 9-14, but do have one ICYMI…

You know how we’ve shown the cool Stream transcription and facial indexing features? We mentioned in briefly, but you now own that ability across almost ALL O365 license tiers!

Read the GOOD kind of fine print by Clicking Here

To watch the episode, Click Here

More Intelligent Content Access -Current + Futures

https://www.microsoft.com/en-us/microsoft-365/blog/2018/08/28/microsoft-365-is-the-smartest-place-to-store-your-content/

  • File Insights
  • Intelligent sharing
  • Searchable images

ICYMI: Office Lens + Ink/Text

https://techcommunity.microsoft.com/t5/Office-365-Blog/Ink-annotations-in-Office-Lens/ba-p/193565

  • Ink+Text annotations in Office Lens

Test Flows w/Real Data

https://flow.microsoft.com/en-us/blog/test-data-management-connectors/

  • Supported at the moment by 4 connectors
  • More coming over time

ICYMI: Power Suite Release Docs for October updated late August

https://docs.microsoft.com/en-us/business-applications-release-notes/october18/

  • Go check out the PA/Flow announcements

Documented Full O365 MC/SC Flow

https://flow.microsoft.com/en-us/blog/get-office365-health-notices-using-microsoft-flow/

  • Same one we’ve shown, but with full docs and step-by-step 🙂
  • Also, trusted app, so it is better than my U+P rev – I was trying to crawl/walk/run, but this is the recommended approach for sure

 

No OFF for 2018-08-23

No OFF this week – not all bad news though! The August episode recordings are now up (AT LAST!) and July is streaming back in w/notes and all. Todd and I will be back next week with continued Office Graph demos and news. Have a great weekend all!

OFF 2018-07-27

To watch the episode Click Here

Power BI Report Server Update for August 2018
https://powerbi.microsoft.com/en-us/blog/power-bi-report-server-update-august-2018/

Highlights:

• Report theming
• Buttons
• Table & matrix tooltips
• Print to PDF in Power BI Desktop!
• New DAX: COMBINEVALUES
• Measure drill through in reports
• Conditional formatting by separate field

Power BI PowerShell Guidance
https://powerbi.microsoft.com/en-us/blog/working-with-powershell-in-power-bi/

Great examples and guidance for admins, developers, users, etc.

Flow in Excel Guidance
https://flow.microsoft.com/en-us/blog/introducing-microsoft-flow-integration-in-excel/

PowerApps and Flow Governance Whitepaper
https://powerapps.microsoft.com/en-us/blog/powerapps-enterprise-deployment-whitepaper/

Initial set of guidance around environment management, user administration, understand data generated by these services, etc.

PowerApps October 2018 Release Notes
https://powerapps.microsoft.com/en-us/blog/october-2018-release-notes-available-to-download/

• Focus on quality in the service
• Solution checker will provide guidance around performance and stability
• Continued unification of Canvas and Model-driven Apps (CDS)
• Check out the full PDF: https://go.microsoft.com/fwlink/p/?linkid=2005971
• Theming updates (Office, high contrast)

PowerApps Attachments for CDS Entities
https://powerapps.microsoft.com/en-us/blog/add-attachments-to-your-common-data-service-entities/