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 lot of ways to connect a service desk web to PBI:

1- This post:

https://powerbitalks.com/2024/01/unlocking-seamless-integration-connecting-power-bi-to-jira-using-rest-api.html

 

2 - The Jira content Pack

3- Several posts like this one:

https://community.fabric.microsoft.com/t5/Power-Query/Connect-to-Jira-with-Power-BI-code-for-a-function/td-p/3205892 

 

I have tried an Anonymous connection, a "Credential" one using my user and the API Token, the Base64 form for the first option... And I always end up in this scenario (The code on the right side has been hidden for privacy reasons):

 

The jira url I'm copying is https://mycompanyname.atlassian.net, perhaps the problem is there because I'm missing something.

 

Please if someone has encountered this before, the help would be hugely appreciated!

 

Thank you

 

 

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.

2 Replies

  • 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.