Extract from JIRA to Power BI (using Power Query)
Вставка
- Опубліковано 11 лип 2024
- Join me today as I show you how to pull data directly from JIRA into Power BI, simplifying your data management processes. Whether you're a project manager or data analyst, this guide ensures you make the most out of JIRA's capabilities without needing additional tools.
🔍 What You'll Learn:
Setting up API tokens in JIRA for secure data extraction.
Integrating JIRA with Power BI for real-time data analysis.
Tips for efficient data management within projects.
🔗 Resources:
My video about Offset APIs: • Extracting Data from O... .
JIRA API Documentation: developer.atlassian.com/cloud....
Source File: / extract-jira-to-102754879 (It's FREE!).
🕒 Timestamps:
00:00 - Introduction to Data Extraction from JIRA
00:49 - Initial Setup in JIRA to get API Token
01:56 - Setting up Parameters in Power BI
03:36 - Querying Issues from JIRA in Power BI - M Code Walkthrough
10:02 - Managing Paginated API Responses
13:38 - Authentication
14:16 - Extracting Worklogs from JIRA
🎥 More about Power BI:
- Power BI Tips & Tricks: • Power BI Tips & Tricks
- APIs in Power BI: • Working with APIs in P...
- Analytics in Power BI: • Analytics in Power BI
- Deneb in Power BI: • Deneb in Power BI
✅ Subscribe for More: Follow my journey into data-driven project management and get practical tech tutorials by subscribing to Introverted Manager.
💡 Share Your Experience: Have you integrated JIRA with Power BI in your projects? Drop your tips and challenges in the comments!
___
Music I Use: Bensound.com/royalty-free-music
License code: ZUKCUFORL3LKXGJS
Very excited to try this, thanks for the thorough video!
Thanks for watching! 😊
Is this code published so I can make a copy? Do I need a connector for Jira to Power BI or vice versa?
Is there a step missing after I generate the API token, where do I use it? I am getting the error (400): Bad Request
You have to add token in api key parameter within Power BI in Power Query
whats the difference btween using the power bi conector for jira extension instead
?
M approach is for cases when you’re unable to add additional extensions or cannot query DB (for on-prem) but still want to collect data, API on the other hand is *usually* freely accessible
Hello, first of all thanks for this video, it is awesome!! I have a question for you. In case than we have issues with more than 20 worklogs inside but the field maxResult is 20, is there a way to get all this work logs?? Me and a lot of people are struggling with this but we can't to find a solution. Thank you for advance!
Hello, I have tried the above with our JIRA instance and anytime I publish the version I get an error message Some data sources may not be listed because of hand-authored queries. Based on that it is not possible to schedule an automated refresh. Do you have any pointers or directions that can help?
I would have to agree with Inna’s comment.
In its current state this M script isn’t production ready, as Power BI service applies a lot of limitations to dynamic scripts.
Consider this video as an educational about M capabilities and working with APIs, applicable for ad-hoc analysis.
If you have opportunity to use custom connector, go with the connector - that would be easier.
@@introverted.manager I found a solution to the problem with publishing. Modify the query based on the article "Using The RelativePath And Query Options With Web.Contents() In Power Query And Power BI M Code" by Chris Webb and article "Dynamic Web.Contents() and Power BI Refresh Errors" by Stacia Varga
Awesome video, thank you! When publishing to the PowerBI Web Service, it doesn't recognise the data source as valid. Do you have a workaround for this? I've found some online, but none of them seem to work.
Could you share the exact error you’re getting?
Thank you for uploading this video. It works as expected with manual refresh. But when we try to schedule the refresh we get error: " You can't schedule refresh for this semantic model because the following data sources currently don't support refresh: Data source for Query1" this is due to dynamic data source. So, I am having difficulties while adding relativepaths within M query. Could you please suggest on this?
Hi, this is indeed the case - there are lots of limitations imposed on refreshes in the service.
There are certain workaround, let me have a look whenever I get time.
Hi, how can I include the created dates in the BaseUrl? For example from 4/1/2024 to 5/1/2024? Thank you in advance!
Hi!
You can add this string into baseUrl:
and created >="yyyy/MM/dd" AND created
Hod did you extract the date from Jira and import to power Bi that part is not much clear to me because u have no no knowledge of Bi, so minute 1:57 not much clear to me, tnx!
You can download source file (in the video description) and open it in Power BI Desktop to review.
Make sure to change api key and URL in the parameters (click Transform data to get there).
@@introverted.manager where we must change the API KEY please ?