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,
I'm getting the below error while refreshing the jira data. apriciate your help.
Thank you
Hi,
any ideas on the this DataSource error issue. is there something missing in the below query or more information required?
= Json.Document(Web.Contents("https://myjira.xxx.com/rest/api/2/search?jql=project in ('yyyy')&maxResults=5000"))
Thank you,
Deo Yadav
Hi @DeoYadav ,
Please review the following links and check if they can give you some insights or solution.
We have done it using REST API, lot of work.
https://developer.atlassian.com/cloud/jira/platform/rest/v3/intro/#permissions
You can check this odata option in this blog -https://www.idalko.com/power-bi-jira/
Source = Json.Document(Web.Contents(JIRA_URL & "/rest/api/2/search?jql=" & QUERY))
Best Regards
Hi @v-yiruan-msft, thanks for your help but I'm having now different error as below in screenshoot. could you please suggest me on this that what's exact reason?
Thank you,
Deo
Hi @DeoYadav ,
According to the error message, it seems that you don't have the proper permission to access to the url. Please update the codes as below and check if it can work...
= Json.Document(Web.Contents("https://myjira.xxx.com/rest/api/2/search?jql=project =yyyy and maxResults=5000"))
Best Regards
@v-yiruan-msft thank you again, this url is working in the browser after excluding the maxresults=5000 parameter from the url but not working in Power BI and it gives the same error. when I'm trying this url including maxresults=5000 parmameter, it's not working, says
{"errorMessages":["Field 'maxresults' does not exist or you do not have permission to view it."],"errors":{}}
Apriciate if any other help!
Thank you
Deo
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.
User | Count |
---|---|
13 | |
2 | |
2 | |
1 | |
1 |