- 2 minutes to read

How does Nodinite Dynamics monitoring integrate with Power BI for reporting?

The Nodinite Web API exposes Dynamics monitoring data as REST endpoints consumable by Power BI:

Available Data

  • Workflow execution statistics - Success rate per workflow (last 7/30/90 days), error count by error type (TimeoutException, NullReferenceException, SecurityException, etc.), execution duration trends (min/max/avg/p95), execution volume per workflow per day
  • License consumption metrics - Active users vs inactive users (30/60/90 day thresholds), license type distribution (Enterprise/Professional/Team Member), license cost per type, inactive user cost (87 users × $95/month = $99K/year waste)
  • User activity data - User login frequency (logins per day/week/month per user), session duration trends, login patterns by role (Sales reps login 8 AM - 6 PM weekdays, Customer Service 24/7 rotation)
  • Alert history - Alert count by severity (Warning/Error/Critical), alert count by workflow, MTTR (Mean Time To Resolution), unacknowledged alert duration

Example Power BI Reports

  1. Executive Dynamics 365 Health Dashboard - Overall CRM health score (weighted: workflow success rate 40%, user adoption 30%, license optimization 30%), month-over-month error rate trend, top 10 failing workflows, license waste opportunities ($180K savings identified)
  2. License Optimization Report - Inactive users list (87 users, last login dates, license cost $99K/year), over-licensed users (62 users, current vs recommended license tier, $64K/year savings), duplicate licenses (34 users, $38K/year savings), ROI projection (deprovision all = $202K annual savings)
  3. Workflow Performance Report - Workflow execution duration trends (12 months, identify gradual performance degradation), success rate by workflow (identify consistently failing workflows requiring attention), execution volume trends (forecast capacity requirements)

Setup

Power BI Desktop → Get Data → Web → Enter Nodinite Web API URL (e.g., https://nodinite.company.com/api/Monitoring/Dynamics365/Workflows?startDate=2024-01-01&endDate=2025-01-15) → Enter API key (generated in Nodinite Web Client → Settings → API Keys) → Load data → Build reports.

Refresh Schedule

Power BI Service scheduled refresh (daily at 6 AM), data exported from Nodinite Web API each refresh, historical data retained in Power BI dataset.

Next Step

Browse more Microsoft Dynamics 365 FAQ topics in the Troubleshooting Overview.