After some community requests and after I published a series of blog posts, a step-by-step configuration for publishing BizTalk operational data to Power BI is available as a whitepaper!
Recently, the Microsoft Product team released the first feature pack for BizTalk Server 2016 (available only for the Enterprise and Developer editions). This whitepaper will help you understand how to install and configure one of the new features of BizTalk Server 2016:
- Leverage operational data – View operational data from anywhere and on any device using Power BI, and learn how to configure it.
📝 One-Minute Brief
A practical guide and whitepaper explaining how to expose BizTalk Server 2016 operational data in Power BI. It walks through prerequisites, installation, and configuration steps to enable real‑time operational visibility across environments using Microsoft’s built‑in features.
What to expect about Step by step configuration to publish BizTalk operational data on Power BI
This whitepaper will give a step-by-step explanation of what components or tools you need to install and configure to enable BizTalk operational data to be published in a Power BI report.
Table of Contents
- About the Author.
- Introduction.
- What is Operational Data?
- System Requirements to Enable BizTalk Server 2016 Operational Data.
- Step-by-step Configuration to Enable BizTalk Server 2016 Operational Data Feed.
- First step: Install Microsoft Power BI Desktop.
- Second step: Enable operational data feed.
- Third step: Use the BizTalk Server Operational Data Power BI template to publish the report to Power BI.
- Fourth step: Connect the Power BI BizTalkOperationalData dataset with your on-premise BizTalk environment.
Where can I download it
You can download the whitepaper here:
I would also like to take this opportunity to say thanks to my amazing team at BizTalk360 for the proofreading and for once again joining me to publish another white paper for free.
I hope you enjoy reading this paper, and any comments or suggestions are welcome.
Hi Sandro
Thank you for a good article series on the BizTalk operational data. Have you had any problems to get anything else than the 50000 last message events from the BizTalkOperationalDataService/TrackedMessageEvents? I cannot seem to get it to return anything but 50k last events. Our BizTalk environment handles 3-4 million events per day which basically renders the operational data service useless which is a shame since we want to be able to use it. Have a nice day Sandro!