PowerBi / PowerQuery Jira Template

Jira.pq

let
    // Get total
    Source = Json.Document(Web.Contents(JiraRootUrl&"/rest/api/2/search?jql=filter="&JiraFilterId&"&maxResults=1&fields=["&JiraFields&"]")),
    total = Source[total],
    
    GetChunk = (previousTable, maxResults as number) as table => 
    let        
        startAt = if previousTable = null then 0 else Table.RowCount(previousTable) + 1,
        maxRes = if (maxRows - startAt < maxResults) then maxRows - startAt else maxResults,
        MergedTable = if (startAt > total) or ((maxRows>0) and (startAt > maxRows)) then previousTable else 
            let
                Chunk = Json.Document(Web.Contents(JiraRootUrl&"/rest/api/2/search?jql=filter="&JiraFilterId&"&fields=["&JiraFields&"]&maxResults="&Text.From(maxRes)&"&startAt="&Text.From(startAt))),                    
                ChunkTable = Table.FromList(Chunk[issues], Splitter.SplitByNothing(), {"Column1"}),
                table1 = if previousTable = null then ChunkTable else Table.Combine({previousTable,ChunkTable}),            
                table2 = @GetChunk(table1, maxResults) // recursive call
            in
                table2
    in MergedTable,

    IssuesTable = GetChunk(null,maxResults)
    
in
    IssuesTable

Explanation and PBI template can be found here https://tdalon.blogspot.com/jira2powerbi