Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi there,
I am trying to configure a report to automatically refresh that use Jira as it's source and getting the following message:
The report I have created requires parameters of the Jira URL and Project Key:
I have tried reading about RelativePath but struggling for what the solution is....can anyone advise?
Solved! Go to Solution.
The solution was:
= Json.Document(Web.Contents(#"Jira URL",[RelativePath = "/rest/api/2/search?jql=project%20%3D%20" & #"Project Key" & "%20AND%20resolved%20%3E%3D%20-52w%20AND%20issuetype%20not%20in%20(Epic)%20order%20by%20created%20DESC"]))
The solution was:
= Json.Document(Web.Contents(#"Jira URL",[RelativePath = "/rest/api/2/search?jql=project%20%3D%20" & #"Project Key" & "%20AND%20resolved%20%3E%3D%20-52w%20AND%20issuetype%20not%20in%20(Epic)%20order%20by%20created%20DESC"]))
Can you provide an answer that considers my parameters and their names? Otherwise this isn't a helpful response 😞
Sorry I'm not sure what that should be given the names of my parameters and the text given what I currently have:
= Json.Document (Web.Contents(#"Jira URL" & "/rest/api/2/search?jql=project%20%3D%20" & #"Project Key" & "%20AND%20resolved%20%3E%3D%20-52w%20AND%20issuetype%20not%20in%20(Epic)%20order%20by%20created%20DESC"))
Could you elaborate?
Try something like this:
let
Source = Json.Document(Web.Contents("https://companyname.atlassian.net/rest/api/3/search?jql=project in ('TEST')", [Headers=[Authorization="Basic " & Credentials]])),
Hi @FlowViz
Try below it should work:
let
Source = Json.Document(Web.Contents("API URL", [Headers=[#"Authorization"="Token <<TOKEN>>"]])),
....
....
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.