Hello Community,
I'm facing an issue with auto refresh for Power BI dashboard integrated with JIRA SD Cloud. Below the error after using REST API 3:
This dataset includes a dynamic data source. Since dynamic data sources aren't refreshed in the Power BI service, this dataset won't be refreshed. Learn more: https://aka.ms/dynamic-data-sources. |
Below the used code:
fnGetAllJiraIssuesWithAllFields: (jiraDomain as text, optional nextPageToken as text) => let // Build the request URL, adding the nextPageToken parameter if it exists url = jiraDomain & "/rest/api/3/search/jql" & (if nextPageToken = null then "" else "?nextPageToken=" & nextPageToken),
// Fetch the current page of data Source = Web.Contents(url, [Query=[jql="project=ProjectName", fields="*all", maxResults="1000"]]),
// Convert the response to JSON Json = Json.Document(Source),
// Get the issues from the current page Issues = Json[issues],
// Recursively fetch the next page if a nextPageToken exists NextPageIssues = if Record.HasFields(Json, "nextPageToken") then @@fnGetAllJiraIssuesWithAllFields(jiraDomain, Json[nextPageToken] else {},
// Combine the issues from the current page and all subsequent pages AllIssues = Issues & NextPageIssues in AllIssues |
GetIssues:
let JiraDomain = "https://SERVERNAME.atlassian.net", // Replace with your Jira domain Source = fnGetAllJiraIssuesWithAllFields(JiraDomain, null), TableFromList = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error), #"Expanded Column1" = Table.ExpandRecordColumn(TableFromList, "Column1", {"expand", "id", "self", "key", "fields"}, {"Column1.expand", "Column1.id", "Column1.self", "Column1.key", "Column1.fields"}) in #"Expanded Column1"
|
|