- 2 minutes to read

Microsoft Dynamics 365, FAQ, Troubleshooting, Common Questions Microsoft Dynamics 365, FAQ, troubleshooting, common questions How does Nodinite Dynamics monitoring integrate with Power BI for reporting?

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

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.

See all FAQs: [Troubleshooting Overview][]