Forum Discussion
Too much data? (Consuming the JIRA ChangeLogs)
Hi all,
I modified the queries to avoid the lead time to generate information following the steps mentioned in the URL below and it works like a charm. Hope this helps who are looking for solution to retrieve data from JIRA.
Kind regards,
A!
https://stackoverflow.com/questions/46904641/play-with-paginated-data-with-power-bi
Hi all,
I modified the queries to avoid the lead time to generate information following the steps mentioned in the URL below and it works like a charm. Hope this helps who are looking for solution to retrieve data from JIRA.
Kind regards,
A!
https://stackoverflow.com/questions/46904641/play-with-paginated-data-with-power-bi
Hello Anonymous ,
Thanks for sharing the link and your solution. I am also trying to read changelogs from JIRA like you did. But I am not able to follow the link and implement those steps for the M query you wrote above:
let
SearchIssue = () =>
let
Source = FetchPages("", 500),
table = Table.ExpandRecordColumn(Source, "Column1", {"id"}, {"id"}),
Search = (id) =>
let
Issue = Json.Document(Web.Contents(URL & "/rest/api/2/issue/" & id & "?expand=changelog"))
in
Issue,
Output = Table.AddColumn(table, "incidencia",each Search([id]))
in
Output
in
SearchIssueCan you please help with some pointers on how you achieved it? Really appreciate your help in this regard.
Regards,
Anuj