Data pulled to Power BI #11
-
|
Good morning, I have your connector working but I have a question. I would like to create a dashboard of my own that includes the custom fields I created (contact type, category and so on). Is there a way to tweak your API to tell it to grab more tables? Thank you, |
Beta Was this translation helpful? Give feedback.
Replies: 7 comments 2 replies
-
|
Thanks for the feedback/question @AJ-Greiner. Yes you can do that 👍 You will have to go into Power Query and some of the previous steps in the data transformation to find the additional columns.
You need to go to the step before that called _Expanded - this is where you'll find the fields: Be mindful you'll need to do this in each table....plus the custom fields may be hard to find - Jira just called them CustomField_nnnn |
Beta Was this translation helpful? Give feedback.
-
Beta Was this translation helpful? Give feedback.
-
|
Yes you need to keep expanding - And select the fields you want - sometimes you'll need to expand to new rows, sometimes extract values. Typically if you get an error after doing that you should go back and do the opposite... |
Beta Was this translation helpful? Give feedback.
-
Beta Was this translation helpful? Give feedback.
-
Beta Was this translation helpful? Give feedback.
-
|
Yes - you would just remove anything from the JQL that pertains to status, that way it will bring everything in :) |
Beta Was this translation helpful? Give feedback.
-
Beta Was this translation helpful? Give feedback.
-
|
So for example if you did it for the WorkItems Completed table, you would remove the following: You also need to make your queries match with the startat2,3,4 etc. as this is how it does the pagination of results - if they don't match it will bring an error. If you get stuck, feel free to email me (nicolas.brown@outlook.com) and happy to have a call to help you out :) |
Beta Was this translation helpful? Give feedback.
-
Beta Was this translation helpful? Give feedback.
Thanks for the feedback/question @AJ-Greiner. Yes you can do that 👍
You will have to go into Power Query and some of the previous steps in the data transformation to find the additional columns.
There is a common step called Expanded Data.Fields where the fields I have used have been expanded:
You need to go to the step before that called _Expanded - this is where you'll find the fields:
Be mindful you'll need to do this in each table....plus the custom fields may be hard to find - Jira just called them CustomField_nnnn