Turn Raw Data into Actionable Insights: Monitoring Business Central Telemetry with Power BI
Welcome back to the podcast and our companion blog! If you have ever felt like your organization is operating in the dark when it comes to system performance, you are definitely not alone. Many businesses deploy Microsoft Dynamics 365 Business Central, open their digital doors, and immediately start flying blind without any real visibility into how their people actually use the platform or where performance bottlenecks lurk. Fortunately, there is a straightforward solution. In this post, we are going to dive deep into how you can transform complex telemetry logs into clear, actionable dashboards using Power BI and Azure Application Insights. Be sure to check out the accompanying podcast episode, Monitor Business Central Telemetry with Power BI, for an even deeper dive into these concepts.
Why Use Telemetry?
What Telemetry Tracks
You can use telemetry to collect a wide range of data from your system. This data gives you a clear view of how your organization uses Dynamics 365 Business Central. Here are some examples of what telemetry tracks:
- User activities, such as onboarding and permissions changes
- Database blocks and lock time-outs
- Success and failure rates for sign-in attempts
- Inquiry wait times
- Modifications to configuration or environment
- Number of page views and reports generated
- Email sending failures
- Job queue creation and execution
- Table indices added or removed
- Error logs and performance metrics
This information helps you understand how your system works every day. You can see where users spend their time and which features they use most. Telemetry also provides transparency, making it easier to spot unexpected changes or issues.
Business Benefits
When you enable telemetry, you unlock several important benefits for your business. You can quickly diagnose and troubleshoot problems without searching through logs. You gain insights into daily operations and user activities. This helps you make better decisions and improve efficiency.
High-fidelity telemetry enables automated detection of anomalies and enhanced alerts that connect operational conditions to business impact.
You can also use telemetry to analyze trends. For example, you might notice a pattern of slow page loads or frequent errors. This allows you to address issues before they affect your users. Telemetry supports proactive troubleshooting, so you can prevent problems from getting worse.
Some key business benefits include:
- Faster investigation of system behavior
- Early detection of incidents to prevent escalation
- Improved user engagement through better system performance
- More informed capacity planning based on real data
- Consistent governance and reliability with a centralized view of system health
Common Scenarios
You will find telemetry useful in many everyday situations. For instance, you might want to track how often users access certain pages or features in business central. If you notice a drop in usage, you can investigate and make improvements. You can also monitor job queues to ensure that important tasks run on time.
In another scenario, you may see delays in high-priority jobs. Telemetry can help you identify the cause, such as queue congestion or resource shortages. You can then adjust your settings to fix the problem. If your finance team struggles with stuck bank reconciliation jobs, telemetry can reveal issues like thread starvation, showing you where to allocate more resources.
You can use Power BI to visualize telemetry data. This makes it easy to spot trends, detect bottlenecks, and share insights with your team. By using telemetry, you stay ahead of potential issues and keep your Dynamics environment running smoothly.
Prerequisites for Enabling Business Central Telemetry
Before you start setting up telemetry in Dynamics 365 Business Central, you need to make sure you have the right tools and permissions. These requirements help you connect your Business Central environment to Azure and unlock powerful analytics with Power BI. Here is a quick overview of what you need and why each item matters:
| Prerequisite | Description |
|---|---|
| Access to Azure | Required to manage the telemetry settings. |
| Business Central Admin Center access | Necessary for enabling and configuring telemetry. |
| Power BI Pro license | Needed for reporting and analytics capabilities. |
Azure Subscription
You need an Azure subscription to collect and analyze telemetry data from Business Central. Azure acts as the foundation for storing and processing your telemetry. With an Azure subscription, you can create resources like Application Insights and Log Analytics workspaces. These resources capture and organize the data that Business Central sends.
- An Azure subscription lets you create and manage the resources needed for telemetry.
- Application Insights and Log Analytics workspaces store and analyze your telemetry data.
- You can monitor system health, track user activity, and spot trends using these Azure tools.
Admin Permissions
You must have admin permissions in both Azure and the Business Central Admin Center. These permissions allow you to configure telemetry settings and connect your Business Central environment to Azure Application Insights. Without admin access, you cannot enable or manage telemetry features.
Admin permissions ensure you can access the Business Central Admin Center, change environment settings, enter the Application Insights key, and save and apply telemetry configurations.
Power BI Pro (Optional)
A Power BI Pro license is optional but highly recommended. Power BI Pro lets you visualize telemetry data and build interactive dashboards. With Power BI, you can turn raw telemetry into clear, actionable insights.
Tip: Power BI Pro helps you get the most value from your telemetry by making data easy to understand and share.
Set Up Azure Application Insights
You need to set up Azure Application Insights before you can collect telemetry from Dynamics 365 Business Central. This process helps you organize, store, and analyze the data that your system generates.
Create Azure Account
You must have an active Azure account to begin. If you do not have one, you can sign up for a free account on the Microsoft Azure website. An Azure account lets you access the Azure portal, where you will manage your resources.
Tip: Use your work or school email address when you register. This makes it easier to manage permissions and collaborate with your team.
Add Application Insights Resource
After you sign in to the Azure portal, you will add a new Application Insights resource. This resource collects and processes telemetry data from your Business Central environment. Follow these steps to organize your setup:
- Create a resource group in the Azure portal. This group helps you keep all your telemetry resources together.
- Set up a log analytics workspace. This workspace stores the log data that Azure Application Insights collects.
- Configure Application Insights to connect to your log analytics workspace. This step ensures that all telemetry data flows into one place for easy analysis.
Get Instrumentation Key
When you enable Application Insights, you need an instrumentation key. This key links your Business Central environment to Azure Application Insights. You will find the instrumentation key in the overview section of your Application Insights resource. Copy the instrumentation key and keep it in a safe place for the next step.
Enable Business Central Telemetry
Access Admin Center
To enable Business Central telemetry, you first need to access the Business Central Admin Center. This is the main control panel for your Dynamics 365 Business Central environments. Select the environment where you want to enable telemetry.
Configure Telemetry Settings
After you select your environment, you can configure the telemetry settings. These settings control how your system collects and sends data to Azure Application Insights. You will see a section labeled "Telemetry" or "Monitoring" in the environment settings.
You can review and determine the cause of performance issues, see all system and application errors with detailed analysis, review application usage, and review user access and behaviors.
Enter Application Insights Key
The next step is to connect your environment to Azure Application Insights. You do this by entering the Application Insights key or connection string into the designated field in the telemetry settings.
Save and Apply
After you enter your Application Insights key, you need to save and apply your changes. This step activates telemetry for your selected environment in Dynamics 365 Business Central, making your configuration live and ready to collect data.
Connect Dynamics 365 Business Central to Application Insights
After you enable telemetry in your environment, you need to make sure that Dynamics 365 Business Central connects properly to Application Insights. This connection allows you to collect and analyze important data about your system’s health.
Verify Telemetry Connection
You should always verify that your telemetry connection works as expected. Open your Application Insights instance in the Azure portal, check your tables, and verify that incoming data traces appear when users interact with the application.
Test Data Flow
Once you verify the connection, perform a common action in Dynamics 365 Business Central, such as signing in or running a report, and wait a few minutes for the data to reach Application Insights to confirm the data pipeline is fully functional.
Analyze Telemetry with Power BI
You can turn telemetry data from Dynamics 365 Business Central into clear, actionable insights using Power BI. This tool helps you see patterns, spot issues, and share information with your team.
App Usage Analytics App
The App Usage Analytics app in Power BI gives you a fast way to start analyzing your telemetry. Microsoft designed this app to help you save time and avoid complex data modeling by providing pre-built reports and dashboards.
Build Custom Dashboards
You can build your own dashboards in Power BI to focus on the metrics that matter most to your business. Custom dashboards let you dig deeper into system performance and user behavior.
Share Insights Across Teams
Sharing insights with your team is easy in Power BI. You can give everyone access to the same reports and dashboards, which helps your team stay informed and work together efficiently.
Automate Telemetry Setup
Automating telemetry setup in Dynamics 365 Business Central saves time and reduces errors. You can use built-in tools to deploy telemetry across many tenants or environments.
Deployment for Multiple Tenants
Managing telemetry for several tenants can feel overwhelming. You can use the Telemetry Setup wizard in your Business Central Admin Center to enable insights for every environment you manage at once.
Streamline Configuration
You can streamline telemetry configuration by adding connection strings directly in the Tenant Admin Center for environment-wide telemetry, or within extension manifests for app-specific monitoring.
Troubleshoot Telemetry Issues
Even with a smooth setup, you might face some common issues when working with telemetry. Knowing how to spot and fix these problems helps you keep your monitoring reliable.
- Connection Errors: Double-check keys, ensure outbound traffic is allowed, and review firewall settings.
- No Data in Application Insights: Confirm settings were saved, wait a few minutes, and perform actions in Business Central to trigger events.
- Permission Problems: Verify your user account holds administrator rights in both the Business Central Admin Center and Azure portal.
Best Practices for Telemetry Management
Data Privacy and Security
Protect your organization's data by following internal privacy policies, limiting access to verbose telemetry logs, and utilizing role-based access controls in Azure.
Optimize Telemetry Performance
Collect only the data you need to prevent system slowdowns and storage bloat. Set up appropriate filters, sampling rates, and daily caps within Application Insights.
Regular Review and Maintenance
Regularly check your telemetry dashboards, review weekly error logs, and update filters as your business processes evolve to maintain an optimal monitoring setup.
Conclusion
Turning raw telemetry data into actionable insights is one of the most powerful steps you can take to secure, optimize, and future-proof your Dynamics 365 Business Central environment. By setting up Azure Application Insights, connecting your systems, and leveraging Power BI dashboards, you move away from guesswork and embrace data-driven decision-making. Don't forget to listen to the companion podcast episode, Monitor Business Central Telemetry with Power BI, for more expert discussions and practical tips!
Founder of M365 Show, M365con.net & m365.fm
Mirko Peters is a Microsoft 365 expert, content creator, and founder of m365.fm, a platform dedicated to sharing practical insights on modern workplace technologies. His work focuses on Microsoft 365 governance, security, collaboration, and real-world implementation strategies.
Through his podcast and written content, Mirko provides hands-on guidance for IT professionals, architects, and business leaders navigating the complexities of Microsoft 365. He is known for translating complex topics into clear, actionable advice, often highlighting common mistakes and overlooked risks in real-world environments.
With a strong emphasis on community contribution and knowledge sharing, Mirko is actively building a platform that connects experts, shares experiences, and helps organizations get the most out of their Microsoft 365 investments.
