If you can't see a field, then your Power BI data dictionary is incomplete. You will need to work through every field you want to see on there, work out how it is stored and used in Jira and build the SQL to get what you want
As SQL is the worst possible way to query Jira, this is going to be complex, slow and inefficient for you, as well as potentially needing a change every time someone reconfigures something, and major overhauls on upgrade. Because the SQL is usually inefficent and poor, you should never connect to the production database, and only every connect to a replicated copy, so you at least offload the worst of the resource problems to a non-production server.
Anyway. If you insist on using it. What are the missing fields?
Gaining insight into your team’s effectiveness and choosing the right estimation technique. Estimating projects is hard. It is because people have the tendency to underestimate the time thin...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs