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,

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi DeoYadav ,

    Please review the following links and check if they can give you some insights or solution.

    Connecting Jira to Power BI

    JIRA to Power BI

    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/

    Queries to JIRA from Power BI

    Source = Json.Document(Web.Contents(JIRA_URL & "/rest/api/2/search?jql=" & QUERY))

    Best Regards

    • 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