Forum Discussion

ck_data_analyst's avatar
ck_data_analyst
Frequent Visitor
4 months ago
Solved

Power BI Service refresh fails for Jira API – OAuth error

Hi all, I’m having an issue with Power BI Service refresh when pulling data from Jira Cloud via REST API. Setup Jira Cloud Power BI Desktop → Published to Power BI Service Connection via Web.Co...
  • collinq's avatar
    4 months ago

    Hi ck_data_analyst ,

    I am not a Jira expert, but I did find this:
    This is a known limitation and you can't force Power BI Service to ignore OAuth for Jira Cloud because Power BI will always attempt OAuth resolution for Jira Cloud endpoints.  (THe desktop does not so that is why it works.)

    Therefore, you have to use a gateway or an intermediary like Power Automate or Azure Logic App to get to Jira.

    I also did find this thread:  Solved: JIRA API connection with Power BI - Microsoft Fabric Community   I am not positive that this is exactly your issue but might also help.

  • v-dineshya's avatar
    4 months ago

    Hi ck_data_analyst ,

    Thank you for reaching out to the Microsoft Community Forum.

     

    Hi  collinq  ,Thank you for your prompt response.

     

    Hi ck_data_analyst ,  In addition to collinq  response, i have added another alternative workaround.

    You can try Azure Functions, Please refer below architecture.

    Power BI Service --> Azure Function (HTTP) --> Jira REST API (API token)

     

    Please refer below link.

    Solved: Re: Power bi dashboard from jira works on desktop ... - Microsoft Fabric Community

     

    I hope this information helps. Please do let us know if you have any further queries.

     

    Regards,

    Dinesh