Forum Discussion

DeoYadav's avatar
DeoYadav
Regular Visitor
3 years ago

Web.Content failed to get contents from (400)

Hi, I'm getting the below error while refreshing the jira data. apriciate your help.     Thank you    
Need Help
DeoYadav's avatar
DeoYadav
Regular Visitor
3 years ago

Hi Anonymous, 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

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

  • DeoYadav's avatar
    DeoYadav
    Regular Visitor
    3 years ago

    Anonymous 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