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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.