cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pchemes Frequent Visitor
Frequent Visitor

Can't connect Jira to PowerBi

Hi, tried connecting Jira Cloud in Power BI Web with the standard included app/connector, but no data is shown.  All labels loaded but no data.

Using this URL

https://xxxxxx.atlassian.net where xxxx is my domain

also tried adding the URL with the project name, like:

https://xxxxxx.atlassian.net/projects/AAA

but it never loads data to PBI.

Basic authentication works OK with a Token created in Jira and authentication works OK, actually in Jira it shows token was "used seconds ago".. and refresh in PowerBI shows OK, but all dashboard is empty, only column names are shown.

In Jira I have a lot of issues, and even a few assigned to myself, and I have several projects.

What should I check?

thanks!

JP

1 ACCEPTED SOLUTION

Accepted Solutions
pchemes Frequent Visitor
Frequent Visitor

Re: Can't connect Jira to PowerBi

Fixed the issue, I was using the token name + key to authenticate w/basic auth, which authenticated OK in Jira but with no authorization to pull data.  Fixed that and now PBI gets the data.

 

Now that it syncs data ok, I don´t know how to filter by project (we have many projects in Jira and want to get bugs for a particular one), and it only return a set of xxx records, so I´m not getting the bugs for the project I need.  Is there a way to set those parameters?  (either using the standard PBI app or the pbit)

 

thanks.

JP

View solution in original post

4 REPLIES 4
Community Support Team
Community Support Team

Re: Can't connect Jira to PowerBi

Hi @pchemes ,

Please check if you could get the data successfully in power bi desktop with the JIRA PBIT firstly.

If you still have problems, please share the screenshot of your issue.(Do mask sensitive data before uploading.)

Best  Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
pchemes Frequent Visitor
Frequent Visitor

Re: Can't connect Jira to PowerBi

Thanks for your help.

Just tried with PBI Desktop with the  JIRA PBIT provided and have same issue, no data is shown.   I went to Jira and shows the recent use of the API token.  (I´m using Basic authentication with the API token generated).

Do I have to specify the Project I want data?

Do I have to give some specific authorization in Jira to allow the Token?

Attached the screenshots.

thanks!

Juan

 

Capture1.PNGCapture2.PNGCapture3.PNGCapture4.PNG

pchemes Frequent Visitor
Frequent Visitor

Re: Can't connect Jira to PowerBi

Fixed the issue, I was using the token name + key to authenticate w/basic auth, which authenticated OK in Jira but with no authorization to pull data.  Fixed that and now PBI gets the data.

 

Now that it syncs data ok, I don´t know how to filter by project (we have many projects in Jira and want to get bugs for a particular one), and it only return a set of xxx records, so I´m not getting the bugs for the project I need.  Is there a way to set those parameters?  (either using the standard PBI app or the pbit)

 

thanks.

JP

View solution in original post

whagg55056 Occasional Visitor
Occasional Visitor

Re: Can't connect Jira to PowerBi

@pchemes  What did you specifically do to fix the auth issue? I am hitting the API but no data. 

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (4,735)