Jira Integration with Power BI cannot do auto Refresh (dynamic data source)

[Regional Administrator]

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"

[joris raffin]

Hi ! 

I don't know if you succeed to manage the error, but I had a lot of trouble recently with API and PowerBI. I did a template (pbit) powerBi file with differents functions that make it easy to call your Jira API.

You need to fill the differents parameters and to auth yourself with valid token. 

Compatible with online and desktop.

Djowis/JIRA_PowerBI_Compatible: PBIT file compatible with new jira api

Let me know if you have issues with it