Design Dashboard for Assets Jira

Jorge Antonio Marquez Perez

Hi Community

I've tried to design a dashboard in Power BI to bring in data from the asset module in JIRA, but the data sheet doesn't have a clear correlation for a simple search or dashboard design. Does anyone have an example of a table relationship or visualization design that could help me?

Currently, the Jira and PowerBI connector works without any issues.

thks.

Jeffrey Wolfe

I’ve worked with Jira asset data in Power BI, and it’s rarely straightforward, especially if you’re hoping for simple out-of-the-box tables. The schema from the asset module usually has a lot of custom fields, so the relationships aren’t always obvious.

What’s helped me is to pull in not just the Assets table, but also related tables like Asset Types, Asset History, and Custom Fields. After loading, I use Power BI’s Manage Relationships to manually link them. Usually, assetId or a similar key is what ties things together.

For visualizations, I often start with a basic asset inventory table, then add slicers for asset type or status. If you need to track lifecycle or usage, a matrix visual that includes Asset, Assigned User, and Last Modified works pretty well. If you can share what sort of analysis or dashboard you’re aiming for (inventory, assignments, lifecycle), I can give you a more tailored structure or even share a sample query.