Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Everyone,
I have tried to look for a solution or things to try, but so far have not been successful. Perhaps I am not sure of the correct terminology to use in Power BI, but here it goes.
What I am trying to do is download issues and issue history from cloud based JIRA via its Rest API. I have successfully connected to it and can download the projects, issues, users, etc.
What I need to do is to call the Issues and Issue History endpoint, but I need to provide a parameter for the Issue Key to get the changelog as follows:
https://<url>/rest/api/3/issue/{issueIdOrKey}/changelog
So, what I am trying to achieve is that on my PowerBI Dashboard, I have a slicer which is a dropdown list of all the projects. When you select a project, it should alter a query which collects all the issues in that project and puts them into an Issues Table.
Then, with the new list of Issue Keys, I want to collect the list of changes made to each of those issues and put those into a ChangeLog Table.
Once I have the ChangeLog Table, I will do some calculations to come up with some KPI's, like number of times in a status, number of people assigned, time taken between specific status, and so on.
So far I have a test function which accepts a parameter and I can invoke it via AddColumn. (I just did it for the project key as that is a small dataset to play with).
let function = (projectKey as text) => let Source = Json.Document(Web.Contents("https://testsite.atlassian.net/rest/api/latest/project/" & projectKey)) in Source in function
So with this, I can do AddColumn and get the project details for a list of Project Keys. But I dont understand how to get the value I selected in my slicer, and make it run the function with that parameter, if that is even possible.
hi,@cameronstubber
After my research, values by selected in slicer couldn't alter the query, and currently only Home->Parameters -Manage Parameters is supported to filter data source.
And for your requirement, you could post your new idea in Power BI ideas and make this feature coming sooner .
Best Regards,
Lin
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |