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.Contents
  • Jira service account + API token

What works

  • Refresh works perfectly in Power BI Desktop
  • API token authentication works for issues/boards/sprints

What doesn’t

  • After publishing, manual and scheduled refresh in Power BI Service fail
  • Error:
DMTS_OAuthFailedToGetResourceIdError
Failed to get OAuth resource

Even though I’m using Basic Auth with API token, the Service seems to treat the source as OAuth‑based.

What I’ve tried

  • Clearing all credentials (Desktop + Service)
  • Using API token directly in request headers
  • Setting authentication to Anonymous
  • Static base URL + RelativePath

Still fails with the OAuth error.

Current understanding

It appears that:

  • Power BI Desktop allows interactive authentication and local credential caching
  • Power BI Service requires fully non‑interactive, replayable authentication
  • Power BI Service detects OAuth capability and attempts to resolve an OAuth resource
  • Jira’s 3LO flow requires browser redirects and user consent
  • Power BI Service cannot complete this flow, resulting in refresh failure

Questions

  1. Is this a known limitation of Power BI Service with Jira REST APIs?
  2. Is there any way to prevent Power BI Service from attempting OAuth?
  3. Aside from a gateway or third‑party connector, are there other supported approaches?

Any guidance would be appreciated.

Thanks!

Need Help

4 Replies

  • collinq's avatar
    collinq
    Super User
    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
    v-dineshya
    Community Support
    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

     

    • v-dineshya's avatar
      v-dineshya
      Community Support
      4 months ago

      Hi ck_data_analyst ,

      We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

       

      Regards,

      Dinesh

      • v-dineshya's avatar
        v-dineshya
        Community Support
        4 months ago

        Hi @ck_data_analyst ,

        We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

         

        Regards,

        Dinesh