Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

How to add a "Comments" also while exporting data from JIRA to Power BI via Rest API connection?

It is missing "Comments" while exporting data from Jira to Power BI via Rest API Connection. We do have comments for each issues/incidents/alerts that i want to include as well in the exported data to Power BI.

1 answer

Hi @Rishabh Deshmukh 

If you use the /rest/api/3/search endpoint to get a list of Issues, then you can get comments from the response.
An example response from Jira would be as follows:

"expand": "names,schema",
"startAt": 0,
"maxResults": 50,
"total": 1,
"issues": [
"expand": "",
"id": "10002",
"self": "",
"key": "ED-1",
"fields": {
"comment": [
"self": "",
"id": "10000",
"author": {
"self": "",
"accountId": "5b10a2844c20165700ede21g",
"displayName": "Mia Krystof",
"active": false
"body": {
"type": "doc",
"version": 1,
"content": [
"type": "paragraph",
"content": [
"type": "text",
"text": "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque eget venenatis elit. Duis eu justo eget augue iaculis fermentum. Sed semper quam laoreet nisi egestas at posuere augue semper."
"updateAuthor": {
"self": "",
"accountId": "5b10a2844c20165700ede21g",
"displayName": "Mia Krystof",
"active": false
"created": "2021-01-17T12:34:00.000+0000",
"updated": "2021-01-18T23:45:00.000+0000",
"visibility": {
"type": "role",
"value": "Administrators",
"identifier": "Administrators"

You can learn more about this endpoint here.

You can also use the following endpoints:

GET /rest/api/3/issue/{issueIdOrKey}/comment -

GET /rest/api/3/issue/{issueIdOrKey}/comment/{id} - 

POST /rest/api/3/comment/list -

I recommend that you test the Microsoft Power BI Connector for Jira plugin. With it, you can get the data you need to build reports in Power BI in two clicks. The plugin has a clear interface and you will not have to experience difficulties when uploading data to Power BI.
You can contact us at if you have any difficulties

Best regards,
Demi Kont

Thanks Demi, for quick response.

In my case, in the response, after "fields" i am getting a long list of custom coloumns instead of "Comments". Also currently using rest/api/2, i tried rest/api/3 but it seems to be not working in our Power BI.

Also, it looks like only Jira Admins have the access to install Microsoft Jira Connector for Power BI. But is surely the best way.

Do we have any chance kind of to add comments in one of the custom coloumns?


Hi @Rishabh Deshmukh ,

Above, I indicated an example response from Jira which may contain a comment field, it comes as an array.

You are right about the Microsoft Power BI Connector for Jira plugin, only Jira Administator can install plugins on your Jira instance. You can ask your Jira Administrator to install the plugin and give you access to use it via the "Access Configuration" tab.

Contact us at for additional questions.

Best regards,

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events