Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Jira and Power BI

Dears,   I discovered that I couldn't connect to Jira using Power Bi Desktop. So, I found that I can only connect to jira through Power Bi Service which is available only on the Power BI Account on...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous,

    The JIRA content pack in Power BI Service relies on JIRA API. Based on the discussion, the 100 records limitation occurs on JIRA side.

    In your scenario, please connect to JIRA PBIT I shared above, then change source code in Advanced Editor as discussed in this similar thread.

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Yes it works for me .

I tried your JQL but it seems to give error on the data u are sending as Params in it so please check Again and use the jql of your filter , below is the error I get using your link

{"errorMessages":["The value 'PTL' does not exist for the field 'project'.","Field 'issuetype' does not exist or this field cannot be viewed by anonymous users."],"warningMessages":[]}

I would suggest you go in your JIRA filter and try to use the same using as the query, you an also try using Postman to send the same URL and check the response.

dathompson's avatar
dathompson
Frequent Visitor
6 years ago

It's working now! I was having an authentication issue, which I was able to troubleshoot and solve with Postman. Thank you for that suggestion. I also had to change JiraIDPerPage from 1000 to 100 to return the full dataset. 

 

Thank you again for sharing your code and for your help!

  • golia's avatar
    golia
    Frequent Visitor
    2 years ago

    Hi there , Do you remember how you fixed the Authentication error?