Can I use JIRA as dataset source?

[AliceW]

Hi guys,

I've found a couple of articles on this, but they seem outdated; this is one of them https://powerbi.microsoft.com/en-us/blog/explore-your-jira-data-with-power-bi/

Can anyone tell me if I can create a dataset based on JIRA? Preferably, in the Desktop version like every other set 🙂

Thank you!

Alice

[Anonymous]

Hi Mike282,

Do you know if your solution for AliceW is still working?  I've tried your example and can not get it to work.  I get a 400 Bad Request error.  I can successfully get results using REQBIN, postman, etc..., but not through PowerBI/powerquery. 

Thank you,

Sean

[Mike282]

Hi @AliceW .

I'm working on something similar to you. I've managed to connect to the Jira Web API but needed some help in relation to pagination of issues retrieved (as it looks to only retrieve 50 issues at once) and how the API handles descriptions in a single issue.

In this thread, I'm asking how to handle paging of the retrieved JSON value but you can see how I've setup the credentials. I created a new table and encoded my username and API token in Base64 and used it to authenticate in my other query. 

Figure 1. Create a blank query and enter in your username plus colon plus your API token and then encode it in Base64

You can then create another query and connect to the web API endpoint by using the below code in the advanced editor.

let
    Source = Json.Document(Web.Contents("https://companyname.atlassian.net/rest/api/3/search?jql=project in ('TEST')", [Headers=[Authorization="Basic " & Credentials]])),
    issues = Source[issues],
    #"Converted to Table" = Table.FromList(issues, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"expand", "id", "self", "key", "fields"}, {"Column1.expand", "Column1.id", "Column1.self", "Column1.key", "Column1.fields"})
in
    #"Expanded Column1"

Note that the url endpoint needs to be the one with your company name in the url and you can add in a JQL search parameter in the URL string to extract your specific project. Note you will need to Project Code, which I'm subsituted with "TEST". The "Credentials" part of the header authorization links to the other table I've created with the encoded basic authentication. You can now expand the JSON values. I'm still stuck on a few things related to Pagination but it's a good place to start I think.

You can read more about the thread below:

https://community.powerbi.com/t5/Desktop/Connecting-Jira-to-Power-BI-using-the-Web-API/m-p/838130#M4...

[v-joesh-msft]

Hi @AliceW ,

Have you seen the following post? Basically the same as your question, I hope to help:

Import JIRA Dataset to Power BI Desktop

Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.