Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

JIRA API connection with Power BI

Hi everyone,   I have seen several threats related with the Jira connection via API and people complaining with different issues and errors, but I haven't yet seen mine solved here. I have tried a...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anonymous ,

    According to your screenshot, you seem to have connected to the data source. As for the lack of data display, I suggest you try to limit the number of imports, and then check whether there is data in the table view:



    In addition, about the M code of API:

    let
    url = "http://localhost:8080/rest/api/2/issue/QA-31",
    headers = [
        #"Authorization" = "Basic xxxxx",
        #"Content-Type" = "application/json"
    ],
    response = Web.Contents(url, [Headers=headers])
in
    response


    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Small update: With the Jira content pack I don't get that screen but I get an empty table with a lot of columns:

 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Anonymous ,

According to your screenshot, you seem to have connected to the data source. As for the lack of data display, I suggest you try to limit the number of imports, and then check whether there is data in the table view:



In addition, about the M code of API:

let
    url = "http://localhost:8080/rest/api/2/issue/QA-31",
    headers = [
        #"Authorization" = "Basic xxxxx",
        #"Content-Type" = "application/json"
    ],
    response = Web.Contents(url, [Headers=headers])
in
    response


Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.