You can use Power BI’s powerful tools to create custom reports and dashboards from Atomicwork data. Once connected, your data is kept in sync in near real time, with a maximum delay of about 30 minutes. This ensures that every report you create stays automatically updated with the latest insights.
To set up the integration, connect your PowerBI account with Atomicwork.
Creating a report
To create a custom report from Atomicwork data:
Go to the default PowerBI workspace containing the semantic model named Atomicwork Analytics Data.
Click Create report and select from the four available datasets.
Choose the fields you want to display (e.g., subject, status, created date).
Drag and drop visuals such as charts, tables, and graphs.
Save the report to reuse and refresh automatically.
Filter and refine data
You can narrow down your reports by applying filters that focus on the data most relevant to your teams and timelines. For example:
Use workspace filters to analyze data for specific teams.
Apply date filters with relative ranges (e.g., last 24 hours, last 7 days).
Narrow results further using request type or status.
Automate insights
Beyond manual reporting, Power BI makes it easy to automate delivery and monitoring of Atomicwork data. You can:
Schedule reports to be emailed automatically to stakeholders.
Create KPI-based alerts (e.g., “Notify me if open requests increase by more than 20%”).
Rename dataset fields to match your organization’s terminology.
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.