Power bi dashboard from jira works on desktop not on cloud service

[CarlosPimentel]

Hello 

I have a job requirement that uses Power BI with data from jira connector. In Desktop app everything works, but once I publish to the cloud, neither I can refresh manually from there or even from the Power Automate flow I have created. I have repeatedly got the error failed unknown data source with some id numbers. Tried different approaches already and nothing gets the job done.

[v-priyankata]

Hi @CarlosPimentel 
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[v-priyankata]

Hi @CarlosPimentel 
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-priyankata]

Hi @CarlosPimentel 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[Poojara_D12 · Accepted solution]

Hi @CarlosPimentel 

The issue arises because the JIRA connector in Power BI Desktop works differently from Power BI Service, causing refresh failures after publishing. In Power BI Service, some connectors, including JIRA, may not support direct cloud refresh, leading to the "failed unknown data source" error. One common fix is to use a Power BI Gateway, which acts as a bridge between JIRA and Power BI Service. Alternatively, instead of the JIRA connector, you can use JIRA’s REST API via the Web Connector, which is cloud-compatible. Another possible cause is an expired OAuth token, so re-authenticating in Power BI Service → Manage Connections may help. If using Power Automate, ensure the flow is correctly linked to the dataset with valid credentials. Additionally, you can store JIRA data in a data warehouse like Azure SQL and connect Power BI to it for reliable refreshes. Checking Power BI logs can provide more details if the issue persists.

[CarlosPimentel]

Hi @Poojara_D12 

Thanks for the response. We have a gateway configured and online but still can't refresh. 

Is there a better alternative? Not sure I can use OAuth as the jira board belongs to the company I work for and I am not an admin.

[Poojara_D12]

Hi @CarlosPimentel 

The issue arises because Power BI Service does not support direct refresh for the Jira connector in the same way as Power BI Desktop. While the Desktop version can pull data using your local credentials, once published to the cloud, Power BI Service requires either OAuth authentication or a data gateway, which may not be properly configured or allowed in your organization. Since you are not an admin, setting up OAuth might not be an option. A better alternative is to use Power Automate to extract Jira data into an Excel or SharePoint file, which Power BI can connect to and refresh automatically. Another approach is to use a third-party Jira connector, such as Alpha Serve, or retrieve data through the Jira REST API using Power Query (Web.Contents). If your organization permits, you can also request access to an On-premises Data Gateway (Personal Mode) to establish a secure connection. The most practical workaround, given your constraints, would be automating data extraction through Power Automate, ensuring that Power BI gets updated Jira data without requiring direct API access or admin privileges.

[Akash_Varuna]

Hi @CarlosPimentel ,Have you checked the gateway Power BI requires GateWay to connect to jira 
If using Jira API then check wether the tokens are configured properly
If this post helped please do give a kudos and accept this as a solution 

Thanks In Advance