You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I really don't know why this basic feature is not provided by JIRA. Seems more focus on selling third party apps. Tried searching alot for solution but solutions are flooded with to use particular third party app for connectivity with Power BI.
Finally found a way out from this curl snippest:
echo -n EMAIL:API_TOKEN | base64
curl -D- \
-X GET \
-H "Authorization: Basic TOKEN" \
-H "Content-Type: application/json" \
In power BI > Open Data > Web
I used https://www.base64encode.org/ to get base64 encode string from
Add two headers as shown.
In Authorization enter Basic [Space] your base 64 token
Click ok and you will be connected successfully.
Hi @Vinod Kotiya
I am trying to connect JIRA to Power BI for reporting purpose. But I am unable to get the the basic authentication token, can you help me with this. How do I generate the API token and the connect to POWER PI.
I also want to restrict the data fields for a specific project too.
This is the closest and detailed explanation thread I found, but still since I am new in integration, any help would be appreciated,
Your source m query should look something like this:
Source1 = Csv.Document(Web.Contents("https://YOUR_COMPANY.atlassian.net/sr/jira.issueviews:searchrequest-csv-all-fields/temp/SearchRequest.csv?jqlQuery=project+%3D+%22<PROJECT_SHORT_CODE_HERE>%22+ORDER+BY+created+DESC&atl_token=XXXXXX_lin&tempMax=1000&pager/start=0", [Headers=[Authorization="Basic <Base64_API_TOKEN_STRING>", #"Content-Type"="text/csv"]]),[Delimiter=",", Encoding=65001, QuoteStyle=QuoteStyle.Csv]),
#"Promoted Headers1" = Table.PromoteHeaders(Source1, [PromoteAllScalars=true]),
Again, I chose to export a CSV, but you may export a JSON by using the same URL you use to get the JSON file in your browser.
Hi @Rami Al Halabi
I have another question, lets assume if we do not perform a basic authentication and just want to get the Jira data to PowerBI, so I wondering that in that case what will be the approach.
Also do we have restriction on how many records we can pull and how to pull only the fields of one project.
Thanks for the help and your support.
Hello, in my experience, Basic Authentication did not work. That is why the steps above use an Anonymous connection with an Authorization header that has your generated API token. This is what is authenticating you.
I think there is a 1,000-record restriction on API calls. If you need more records you have to do multiple calls, but feel free to experiment with that. My Jira project does not have 1000 records yet.
For the URL I used, I went to the Issues screen, I filtered the project I want to see > Export Issues Menu > Left-Click on Export CSV (all fields) > Copy Link Address.
Now that I think about it, I'm not using an API call in reality, so the 1000 items limit might or might not be in effect. You'll have to play around with it.
I added "&pager/start=0" to the end of the URL to tell it where to start in case it is returning more than 1000 records.
Oh man, I feel your pain with JIRA! I've been in that same boat before, but your solution seems pretty solid. And it's great that you found a workaround without having to rely on those third-party apps. They can be such a pain sometimes, right? Funny story, I actually had a similar issue when I was working on a project after taking a Power BI training course to get certified as a data analyst. I was super excited to apply my new skills, but integrating JIRA and Power BI turned out to be quite the challenge. I ended up having to do a deep dive into forums just like you did. The struggle is real, haha! Anyway, glad you got it sorted out! Your solution could be a lifesaver for someone else in the same situation. Keep up the good work! 😄👍