This is episode 58 recorded on July 25th 2018 where John & Jason talk about Business Application Summit after-the-fact, The Road Ahead for Power BI & SharePoint blog post, and do a deep dive on the Power BI Desktop update for July.
This is episode 55 recorded on June 28th 2018 where John & Jason talk about a few recent bugs and service interruptions, the recent Power of the Cloud conference, PowerApps, Flow, and some recent improvements to the usability of the On Premises Data Gateway
Organizational Account Authentication has stopped working for Microsoft Graph in Power BI
Easier configuration of Gateway data sets in the Power BI service:
Power of the Cloud show –
IWMentor PowerApps training
Business Applications Summit 7/22-7/24 – https://www.microsoft.com/en-us/businessapplicationssummit
SPSNYC 7/28 – http://www.spsevents.org/city/nyc
SPFest Seattle 8/20-8/24 – https://sharepointfest.com/Seattle/
SPTechCon 8/26-8/29 – http://www.sptechcon.com/
Microsoft Ignite 9/24-9/28 – https://www.microsoft.com/en-us/ignite
European SharePoint Conference 11/26-11/29 – https://www.sharepointeurope.com/
Thrive Conference Dec 4-5 2018 – http://www.thriveconf.com
This is episode 44 recorded on April 9th 2018… where John & Jason talk about the Developer Update & the Gateway Update for March and the Power BI Desktop update for April.
Power BI Desktop – April Update
- Q&A Explorer (preview) *
- Buttons to trigger actions * – ACTIONS! (Bookmark, back, Q&A)
- Combo chart line styles
- Improved default sort for visuals
- Numeric Slicer now generally available
- Organizational visuals now generally available
- Overview by CloudScope
- Icon Map by Altius
- Hexbin Scatterplot
- Adobe Analytics connector now generally available
- SAP HANA connector improvement: Port selection
- Dynamics 365 Business Central connector
John & Jason’s upcoming events
Hey all – John here. One of the things that we get asked frequently is how to report on SharePoint data. The answer is of course, “well, it’s easy, but it depends”.
In the spirit of clearing up the “it depends” part, I’m in the process of writing a series of articles that walks through the nuances of the various SharePoint complex data types. The first one shows some options for reporting on multi-value SharePoint columns, and includes tricks that pertain to more sources than just SharePoint.
You can find the post here. Enjoy!
This is episode 30 recorded in January 1st 2018… where John & Jason talk about the news from the past few weeks in Power BI, Office 365, and Azure.
-includes a number of bug fixes and improvements to previously released features
-matches the Mashup Engine that was released as a part of the Power BI Desktop December update
-This is one of the issues that we run into because Power BI is NOT a part of Office 365
-The solution that Adam shows is a viable, one time solution but does not solve the longer term issue
-This can be scripted to run daily, but it is duplicating groups at that point which will ultimately cause problems
-We love Adam Saxton & Patrick LeBlank and recommend people subscribe to the YouTube Channel GuyInACube
-We don’t actually recommend you do this…
-Point solution for Reddit
-Similar solutions exist for Twitter, Facebook, & Bing News
-What are Solution Templates anyway?
-Who is this for? Social Media Managers… that use Reddit
Server aliases for Azure Analysis Services
-Aliasing is always a good idea
-easier to remember
-obfuscates actual server information
-allows the use of Azure Traffic Manager
-Users can connect to the server from Power BI Desktop (in addition to other client tools) using the link:// format
-Various scenarios are supported, including the following:
-Monitoring of server health
-Derivation of usage metrics
-Understanding which user groups are using which datasets and when
-Detection of long-running or problematic queries
-Detection of users experiencing errors
-Consume diagnostic logs in Power BI
-give you a text file that contains an M expression, which can be pasted into a blank query in Power BI Desktop
-The expression contains the current Log Analytics query and consumes from the Log Analytics REST API
This is episode 26 recorded on December 6th, 2017 from SharePointFest Chicago… where John & Jason talk about the latest updates to the OnPrem Data Gateway, the technical reference implementation for enterprise BI and reporting, and the latest news for Power BI Developers.
Technical reference implementation for enterprise BI and reporting
On-premises data gateway November update is now available
- The public preview of the long-awaited High Availability support.
- The “Additional Logging” setting of the gateway will now include the Mashup engine traces.
- The gateway will now automatically fall back to communicating through Azure Service Bus using HTTPS if direct TCP fails.
- The gateway now includes the November version of the Mashup engine.
Power BI Developer community November update
Azure Resource Manager API
- Scale up/ down
- Pause/ start resource
- Create/ Delete resource
- Get capacity information
- Update capacity
- Get capacity list in a resource group/ subscription
….they will add support for ARM PowerShell soon
Cloud Service Provider purchase channel now available
Visual Options menu and Context menu extension
Injecting custom actions into the options & context menus
Preload API for a better loading experience
Update connection string
RLS support on AS Azure for pre-defined roles
API 1.9 is now available, adding the ability to open the default browser and navigate to a URL
How to clone workspaces using the API
Microsoft’s best practices for building custom visuals in Power BI
This is episode 24 recorded on November 17th, 2017… where John & Jason talk to about the latest Power BI Desktop update, some new custom visuals, and some community contribution picks.
Power BI Desktop November Feature Summary
Stuff John is excited about in November’s Power BI Desktop
- Rule based conditional formatting in tables
- Cell alignment for tables
- Visual ordering in the selection pane (z-order)
- Lock report objects !!!!!!!
- ESRI Plus subscription available….
- Report options for slow data sources in Direct Query (good, but….)
New visuals – Image timeline, Social graph, Venn diagram, HTML viewer
Here’s the complete list of November updates:
- Rule-based conditional formatting for table and matrix
- Cell alignment for table and matrix
- Control visual ordering through the selection pane
- Lock objects on your report
- Esri Plus Subscription is available for ArcGIS Maps for Power BI
- Report options for slow data sources
- Filtering performance improvements
Recently released custom visuals
Data connectivity – Single Sign-on
Impala connector – support for Windows Authentication
check out Episode 23 for more on SSO
Community forum stuff:
Cool infographic that shows what is what in the Power BI space (features w/ license requirements)
Power BI Desktop terminology & definitions
New Office 365 launcher showed up
Flow – Calculate running totals
Stacy Simpkins (@sharepointstacy) blog post about migrating SSRS from one SharePoint farm to another
- Includes version upgrades
This is episode 21 recorded at Microsoft Ignite on September 26th, 2017. This is the last of our Ignite interviews. We had the privilege of sitting down at length with Miguel Llopis, Senior Microsoft Program Manager responsible for Power Query, the On-Premises Data Gateway, and much more.
Miguel has been with Power BI since before there was a Power BI. Listen in – there’s a lot here!
Anne’s Ignite News post:
Office 365 Adoption Content Pack –> 22 reports
2 new usage reporting for Microsoft Teams released at Ignite
The Office 365 Adoption Content Pack in Power BI to go GA at the beginning of 2018 and will be rebranded to Office 365 Usage Analytics
Reports Reader Role
Available as of Sept 27th
Graph Reporting APIs go GA
SharePoint & OneDrive Admin Center updates
To get early access to the preview version of the new SharePoint admin center, please register at https://aka.ms/joinAdminPreview
Office 365 Usage Analytics will be GDPR compliant
Where to find info about Office 365 Reporting information online:
Office 365 Message Center: https://portal.office.com/adminportal/home#/MessageCenter
Office 365 Roadmap: https://www.office365.com/roadmap
Anne & Shilpi’s Ignite sessions
BRK2039: Understand how your users are using Office 365: Introducing Advanced usage reporting tools
Via MyIgnite: https://myignite.microsoft.com/sessions/53327
BRK2011: Understand how your users are using Office 365: What’s new in usage reporting
Via MyIgnite: https://myignite.microsoft.com/sessions/53258
BRK1009: Manage Office 365 more effectively: What’s new in Office 365 administration
Via MyIgnite: https://myignite.microsoft.com/sessions/53331
During Episode 15 of the podcast Jason made his session picks for Microsoft Ignite 2017. Here are his picks:
Office 365, SharePoint, & OneDrive:
Accelerate your digital transformation with SharePoint and OneDrive
Dan Holme, Jeff Teper, Omar Shahine
Session Code: BRK2184
Learn how new and upcoming SharePoint and OneDrive innovations empower people and organizations to share with confidence, transform business processes, engage employees, and harness collective knowledge from anywhere, on virtually any device. During this must-see session, Microsoft Corporate Vice President Jeff Teper, Office, SharePoint and OneDrive, shares the latest innovations and roadmap for content management and collaboration as well as how customers are creating more connected workplaces leveraging Office 365, Windows, and Microsoft Azure.
Support data residency in global organizations with multi-geo support for SharePoint and OneDrive
Sesha Mani, Bill Baer
Session Code: BRK3236
One of the key strengths of SharePoint and Microsoft OneDrive are their inherent resilience and ubiquity: a well planned architecture ensures your data resides in multiple locations, providing resilience and the ability to serve data to partners, customers, and employees wherever they happen to be. In this session we introduce new multi-geo capabilities that allow you to meet your data sovereignty needs and ensure compliance with residency requirements.
Learn from MVPs: Panel discussion on all things SharePoint and OneDrive
Alistair Pugin, Spencer Harbar, Laura Rogers, Wictor Wilen
Session Code: BRK2247
SharePoint MVPs talk about Microsoft SharePoint and OneDrive across the board, be it within Office 365, in Microsoft Azure, on-premises and certainly hybrid. Via a panel Q&A format, these MVP experts expose how online and hybrid improvements increase both deployment scenarios and value. This session is designed to help ITIs and ITDMs find the right cloud formula to deploy based on practical business and technical considerations. This is a must-not-miss session for any IT pro!
Datacenter transformation – a roadmap for platforms, processes, and people
Session Code: BRK3378
Cloud adoption opens a new opportunity for IT pros to play a strategic role in the future of the business by ensuring hybrid cloud assets are secure and well managed. To effectively manage cloud born assets, it’s key to understand how application architectures are evolving through innovations in the cloud platform. Get some advice for how IT practitioners can not only stay relevant, but thrive today while getting ahead of a rapidly changing ecosystem. Join Jeffrey Snover, Technical Fellow, to understand how you can innovate and drive business results faster using Microsoft Azure.
Azure Compute: New features and roadmap
Session Code: BRK3085
A can’t-miss DEMO HEAVY session for everyone working with or considering their strategy for the cloud! We take a look at some of the newest features and upcoming capabilities in the Azure Compute platform. We show some new sizes, new experiences, and new integration technology available during Microsoft Ignite or coming soon across VMs, Azure Service Fabric, Azure Container Service, Azure Functions, and more.
Azure security and management for hybrid environments
Session Code: BRK2405
As organizations continue their digital transformation to the cloud, they are faced with the need to secure and manage resources across hybrid environment. Join this session to learn how Azure security and management services help you address these challenges without any secondary tools, and increase agility for your business. Jeremy Winter, Partner Director in Azure Security and Operations Management, will share the new and upcoming technologies to secure and manage your workloads wherever they are.
What’s new in Azure Active Directory Domain Services
Session Code: BRK3295
Azure AD Domain Services enables you to effectively administer your Azure virtual machines by joining them to a fully managed Active Directory domain in Microsoft Azure. You do not have to worry about deploying, managing, patching, or monitoring domain controllers and can focus on running your workloads in Azure. Users can sign in using their Active Directory credentials and can access resources seamlessly. Azure AD Domain Services provides Group Policy, an easy, familiar way to apply and enforce security baselines on all of your Azure virtual machines. See what’s new in Azure AD Domain Services and explore how you can leverage this service to secure your Azure virtual machines.
Modernize your customer identity management with Azure Active Directory B2C
Session Code: BRK2276
Getting your customers to seamlessly sign-up or sign-in to an application is paramount to its success. Achieving this at scale while following constantly evolving security practices is hard. Come and learn about Azure AD B2C, an enterprise-grade customer identity and access management service, and how it allows you to easily secure your consumer-facing (or citizen-facing) web and mobile applications. No matter where your users live, reach them with customizable user experiences that allow your users to sign-up/sign-in with social accounts such as Facebook or Google, or new accounts in the application.
Understanding hybrid identity, authentication, and authorization with Microsoft Azure Stack
Session Code: BRK4011
Join us for a discussion on hybrid identity and learn how apps can authenticate consistently with Microsoft Azure and Azure Stack. We cover APIs and methods to connect to an Azure instance regardless of whose datacenter it is running on!
PowerShell Unplugged with Jeffrey Snover and Don Jones
Jeffrey Snover, Don Jones
Session Code: BRK3128
Join Jeffrey Snover, the inventor of PowerShell, and Don Jones for their annual PowerShell update. During this talk, you will learn about the latest and coolest PowerShell features to help you automate and manage the hybrid cloud. The focus of this year’s talk is on the PowerShell community, and how it is embracing open-source and transformative change and producing awesome tools.