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.

One Platform Operations, Monitoring and Analytics Software
BizTalk360

microsoft biztalk

Learn more

Over 500 customers across 30+ countries depend on BizTalk360

ServiceBus360

Azure service bus

Learn more

Start managing your Azure Service Bus namespaces in minutes

One Platform - Operations, Monitoring and Analytics Software
BizTalk360

microsoft biztalk

Learn more

Over 500 customers across 30+ countries depend on BizTalk360

One Platform - Operations, Monitoring and Analytics Software
ServiceBus360

Azure service bus

Learn more

Start managing your Azure Service Bus namespaces in minutes

Back to Top