Skip to main content

PowerBI: Overview and capabilities

R
Written by Riya Sebastian
Updated over 3 weeks ago

Integrate Atomicwork to PowerBI to give your team access to raw, real-time Atomicwork data directly in Power BI. You can use Power BIโ€™s advanced analytics capabilities to design reports, track KPIs, and automate insights tailored to your business.

With this integration, you can:

  • Access four datasets from Atomicwork: requests, users, assets, and changes.

  • Build and customize reports to match your unique needs.

  • Apply filters across workspaces, request types, and date ranges.

  • Use relative time filters (for example, last 24 hours or last 7 days) to track trends.

  • Create visuals such as graphs, tables, and KPIs in just minutes using Power BI templates.

  • Schedule reports and deliver them via email to stakeholders.

  • Configure alerts to be notified when KPIs cross thresholds.

Row storage limits

Power BI stores up to 200,000 rows per table using a First-In-First-Out (FIFO) policy. Older rows are automatically removed once the limit is reached.

This typically covers 5โ€“10 months of ticket data, assuming ~4,000 tickets a month with about 10 updates per ticket.

For longer retention, periodically export or sync your PowerBI data to a data lake.

The integration is designed to work across all workspaces in Atomicwork, giving your reporting team a consolidated view of organizational performance.

Did this answer your question?