For years, I’ve wondered why we can run our entire business from Business Central… except Power BI. Refreshes failing? Open another portal. Dataset status? Another page. Errors? Another rabbit hole. So I set out to fix that — and Power BI Monitor is my first attempt to make that happen with an app that brings Power BI management directly into Business Central.
What if you could monitor, manage, and troubleshoot all your Power BI resources without leaving BC? That’s exactly what Power BI Monitor does.
What Is Power BI Monitor?
Power BI Monitor is a Business Central extension that bridges the gap between BC and Power BI, giving you centralized control over your entire Power BI ecosystem. Think of it as your Power BI command center, built right into Business Central.
Key Capabilities
📊 Complete Resource Visibility
Get a unified view of all your Power BI resources:
- Workspaces: See all your Power BI workspaces with access rights
- Datasets: Track every dataset with real-time refresh status
- Dataflows: Monitor dataflow operations and transactions
- Reports & Dashboards: Manage reports and dashboard tiles across workspaces
🔄 Powerful Refresh Management
Take control of your data refresh operations:
- Flexible Refresh Options: Refresh individual resources, selected items, or everything at once
- Real-Time Monitoring: Watch refresh operations in progress with duration tracking
- Smart Automation: Only refreshable resources are processed—no wasted operations
- Complete History: Every refresh is logged with detailed transaction information
🚨 Proactive Error Monitoring
Stay ahead of issues before they impact your business:
- Error Dashboard: See all refresh errors at a glance with 30-day statistics
- Quick Diagnostics: Recent error summary shows problems from the last 7 days
- Drill-Down Analysis: Click any error count to see detailed information
- Performance Metrics: Track success rates, failure patterns, and duration trends
🎯 Built for Productivity
The extension is designed with your workflow in mind:
- Dedicated Role Center: Complete Power BI workspace with everything at your fingertips
- Guided Setup: Step-by-step wizard configures Azure AD authentication in minutes
- Smart Navigation: Jump between related resources and their history effortlessly
- Integrated Experience: Seamlessly extends existing BC role centers
Real-World Benefits
For BI Managers: Monitor all Power BI refresh operations from one location, quickly identify and troubleshoot failures, and track performance trends over time.
For IT Teams: Reduce context switching by managing Power BI alongside other BC operations, automate routine refresh operations, and get immediate visibility into system health.
For Data Teams: Ensure data freshness with proactive monitoring, analyze refresh patterns to optimize schedules, and maintain complete audit trails of all operations.
Getting Started
Setting up Power BI Monitor is straightforward:
- Install the Extension: Deploy it to your Business Central environment
- Configure Authentication: Use the built-in wizard to set up Azure AD authentication
- Sync Your Resources: Pull in your Power BI workspaces, datasets, and dataflows
- Start Monitoring: You’re ready to manage everything from BC
The setup wizard guides you through registering an Azure AD application and configuring API permissions—no deep technical knowledge required.
More information, look here: How to Install and Configure Power BI Monitor for Business Central – think about IT
Under the Hood
Power BI Monitor uses OAuth 2.0 authentication to securely connect with Power BI’s REST APIs. The extension follows a service-oriented architecture with specialized components for different resource types, ensuring reliability and maintainability.
All refresh operations are tracked in comprehensive history tables, giving you complete visibility into what happened, when it happened, and how long it took. Error information is captured with full details, making troubleshooting straightforward.
Who Should Use It?
Power BI Monitor is ideal for organizations that:
- Use Power BI extensively with Business Central
- Need centralized monitoring across multiple workspaces
- Want to automate and track refresh operations
- Require detailed audit trails for compliance
- Value integrated workflows over switching between systems
What’s Next?
This is the very first version of the app — an initial attempt to bring an idea to life: enabling the management of Power BI datasets and refreshes directly from within Business Central. Any ideas or suggestions to improve the app are very welcome.
Ready to try Power BI Monitor? Check out the Power BI Monitor for installation instructions, detailed documentation, and the complete source code.
Power BI Monitor started as a personal frustration turned into a solution — and this first version is just the beginning. My goal isn’t just to make Power BI easier to manage from Business Central, but to learn from real users and shape the app around real-world needs.
If you decide to try it out, I’d love to hear from you.
What works well? What’s missing? What would make your daily Power BI operations easier?
Your ideas and feedback will guide where Power BI Monitor goes next.
Thanks for reading — and if this resonates with you, stay tuned. There’s a lot more coming. 🚀
Ps: How to Install and Configure Power BI Monitor for Business Central – think about IT
Discover more from think about IT
Subscribe to get the latest posts sent to your email.
Hi Steven. This looks super neat! I managed to create the package, installed the extension but I cannot grant group permission and I get this error: Power BI API request failed.
nStatus: 401 (Unauthorized – Check authentication settings and permissions)
nURL: https://api.powerbi.com/v1.0/myorg/groups
nError: Unauthorized – Check authentication settings and permissions
nResponse:
Any workarounds?
If you see this error when testing your connection:
Power BI API request failed.
Status: 401 (Unauthorized – Check authentication settings and permissions)
URL: https://api.powerbi.com/v1.0/myorg/groups
Here’s how to fix it:
1. Verify Your Azure AD App Registration
– Go to Azure Portal → Azure Active Directory → App registrations
– Find your application and check the Client ID matches what’s in BC
– Ensure you copied the correct Tenant ID
2. Check Your Client Secret
– Client secrets expire! Go to Certificates & secrets
– Verify your secret hasn’t expired
– If expired, create a new secret and update it in BC Power BI Setup
– Important: Copy the secret value immediately—you can’t view it again later
3. Confirm API Permissions Are Granted
Your Azure AD app needs these Power BI Service permissions:
–
Dataset.Read.All– Required for reading dataset information–
Dataset.ReadWrite.All– Required for triggering refreshes–
Dataflow.Read.All– Required for dataflow information–
Dataflow.ReadWrite.All– Required for dataflow refreshes–
Workspace.Read.All– Required for workspace access–
Group.Read.All– Required for workspace operationsCritical Step: After adding permissions, click “Grant admin consent” in the Azure Portal. Without admin consent, the app cannot access Power BI APIs even if permissions are added.
4. Wait for Permission Propagation
After granting admin consent:
– Wait 5-10 minutes for changes to propagate through Azure AD
– Clear any cached tokens (re-enter your Client Secret in BC)
– Test the connection again
5. Verify User Permissions
The Azure AD app authenticates as itself, but you also need:
– The BC user must be a Power BI user
– Access to at least one Power BI workspace
– Appropriate Power BI license (Pro or Premium Per User)
Quick Test Checklist:
– ✅ Client ID is correct
– ✅ Tenant ID is correct
– ✅ Client Secret is valid (not expired)
– ✅ All required API permissions are added
– ✅ Admin consent has been granted
– ✅ You’ve waited 5-10 minutes after granting consent
– ✅ You have a Power BI license
– ✅ You have access to at least one workspace
Still having issues? Use the “Setup Instructions” action in Power BI Setup for a detailed step-by-step guide.