BizTalk Server 2016 Feature Pack 1: How to publish BizTalk operational data on Power BI – Step-by-step configuration (Part 1)

Recently, the product team released a first feature pack for BizTalk Server 2016 (only available for Enterprise and Developer edition) and I am trying all these features and at the same time trying to help a little Microsoft BizTalk team improving their documentation, special regarding to these new features that appear with BizTalk Server 2016 Feature Pack 1. In this post, we will address the new Analytics feature of BizTalk Server 2016 associated with BizTalk operational data:

  • Leverage operational data – View BizTalk operational data from anywhere and with any device using Power BI.

What is BizTalk Operational Data?

Operational data, as you can read on Microsoft official documentation here, is all the information on the instances and messages flowing through your BizTalk Server environment. The operational data feed is the same data you get looking at Group Hub in the BizTalk Server Administration console. The feed includes the following data tables:

  • Application data
  • AS2 Status Records
  • Batching information
  • Instance information
  • Interchange Aggregations Records
  • Interchange Status Records
  • Messages
  • Subscriptions
  • Tracked Events
  • Transaction reports
  • Transaction sets

These data can be accessed and queried using visualization tools, including Power BI.

System Requirements to Enable BizTalk Server 2016 Operational Data

For enable BizTalk Server 2016 Operational Data feature available in Feature Pack, you need:

Important note: is required to restart BizTalk Server machine to finish the FP1 installation process.

Note: Feature Packs are not supported in BizTalk Server 2016 Standard Edition.

Step-by-step Configuration to Enable BizTalk Server 2016 Operational Data Feed

First step: Install Microsoft Power BI Desktop

So, the first “new thing” here that we need to install, assuming that we already have Feature Pack 1 and IIS installed, is Power BI Desktop tool. After you download the version of Power BI Desktop that matches the architecture (x86 or x64) of your Windows OS, you should:

  • Run the downloaded .MIS file – in my case: PBIDesktop_x64.msi – from your hard drive.
  • In the “Welcome to the Microsoft Power BI Desktop Setup Wizard” screen, click “Next”

BizTalk Operational Data - Microsoft Power BI Desktop Setup Wizard welcome

  • In the “License agreement” screen, select the option “I accept the terms in the License Agreement” and then click “Next”

BizTalk Operational Data - Microsoft Power BI Desktop Setup Wizard license agreement

  • In the “Destination Folder” screen, review or change the installation path and then click “Next”

BizTalk Operational Data - Microsoft Power BI Desktop Setup Wizard Destination folder

  • In the “Ready to Install Microsoft Power BI Desktop” screen, click “Install” to continue with the installation.

BizTalk Operational Data - Microsoft Power BI Desktop Setup Wizard Ready To Install

  • In the “Completed the Microsoft Power BI Desktop Setup Wizard” screen, click “Finish”

BizTalk Operational Data - Microsoft Power BI Desktop Setup Wizard Finish

For more information about Power BI check https://powerbi.microsoft.com/en-us/.

Related Links

Author: Sandro Pereira

Sandro Pereira lives in Portugal and works as a consultant at DevScope. In the past years, he has been working on implementing Integration scenarios both on-premises and cloud for various clients, each with different scenarios from a technical point of view, size, and criticality, using Microsoft Azure, Microsoft BizTalk Server and different technologies like AS2, EDI, RosettaNet, SAP, TIBCO etc. He is a regular blogger, international speaker, and technical reviewer of several BizTalk books all focused on Integration. He is also the author of the book “BizTalk Mapping Patterns & Best Practices”. He has been awarded MVP since 2011 for his contributions to the integration community.

Leave a Reply

Your email address will not be published. Required fields are marked *

BizTalk360
BizTalk Server

Over 500+ customers across
30+ countries depend on BizTalk360

Learn More
Serverless360
Azure

Manage and monitor serverless
components effortlessly

Learn More
Atomicscope
Business Users

Monitor your Business Activity in iPaaS
or Hybrid integration solutions

Learn More

Back to Top