Power BI connection to Jira data source

[Avram Elena Alexandra _BljP_TEF46_3_]

I want to connect a Power BI report to data from a Jira board. I have attempted two different connections, but neither is working:

1. Direct connection using an API Token.

2. Connection through the 'Power BI Connector for Jira Cloud' marketplace app.

In both situations, the connection fails due to similar errors. I have tried the following methods:

• Connecting via Web -> Basic authorization -> using my credentials (user and generated password from OneIDM) and my API token.

• Connecting via OData Feed using the same method as the Web connector.

• Connecting via Web and using the Advanced option.

• Connecting by creating a blank query and using code in the Advanced Editor (where I tried using the URL only; the URL and token; and the URL, token, and user).

• Using different URLs (recommended paths from Docupedia and various forums, adapting them to my specific URL address).

All of these methods resulted in failure, producing errors such as: 'The credentials provided are invalid,' 'Expression.Error: Access to the resource is forbidden,' 'We couldn't authenticate with the credentials provided,' and 'DataSource.Error: The downloaded data is HTML, which isn't the expected type.'

[David Nickell · Accepted solution]

Good morning -- I think I can help.   I use the REST APIs to pull data into Power BIwithout any additional plugins.  Here is a link to a "Work in Progress" Power BI Report that pulls data from ecosystem.atlassian.net daily (for test data purposes)

https://app.powerbi.com/view?r=eyJrIjoiMWIwNzk5OGMtOGFmNS00NmIzLWE1YzUtN2M2MjZiNDgyNmU2IiwidCI6IjNjZDVhOTg1LTBkM2YtNGM0ZC1hY2M1LTU2NTlhMTJiMTEyMyJ9

If you want to add a single API Endpoint to Power BI, here is one method. 

1. Use a WEB Connection formatted as I show below
2. Include an  AUTHORIZATION HEADER with your Base64 encoded API Token  
3. When prompted for permissions, you will connect ANONYMOUS using ORGANIZATION privacy levels

To get your encoded Basic API token, you can:

• create an api token at https://id.atlassian.com/manage-profile/security
• Encode your user id (email address) + a colon + your token.  You cand do this at Base64Encode.com
• Then add the word Basic, a space, and your encoded token to an authorization header.

I've included some screen shots. Let me know how this goes. 

---

NOTES: 

1. the format of "email:token" is extremely important when you encode.  The format of "Basic encodedtoken" (with a space) is also important
2. Once you get the basics down, you can build reusable functions to use for all of your endpoints.  The example I provide here is very basi

---

Your data source will look like this:

---

encoding at Base64Encode.com will look like this:

[Avram Elena Alexandra _BljP_TEF46_3_]

Do you know if there are any roles, licenses or settings I need to do before hand? I tried everything in connecting and it still doesn't work. 

[quentin_leroy · Accepted solution]

Hello @Avram Elena Alexandra _BljP_TEF46_3_ ,

Thank you for posting your question on Atlassian forum! 

Quentin here from Appfire; we have an alternative that might interest you: the Power BI Connector.

Our application uses your user token when generating the OData connector; you will not have to generate any authentication token yourself, and it will work out of the box. We offer a 30-day free trial, so do not hesitate to try it and provide feedback.

Hope this helps! 

Sincerely,

Quentin

[Daniel Belevtsov · Accepted solution]

Hi @Avram Elena Alexandra _BljP_TEF46_3_ ,

Thanks for your question.

If you are trying to use the connector from Tempo Software, the following credentials should work on the Power BI side:

- Authentication method: Basic;

- Username: your Jira email address;

- Password: the corresponding access token created by your user (note that it is different from a Jira API token): https://help.tempo.io/powerbiconnector/latest/creating-access-token

These tutorials should also be of help:

1.) How to export data into Power BI: https://help.tempo.io/powerbiconnector/latest/importing-jira-data-into-power-bi

2.) How to fix the "Access to the resource is forbidden" error: https://help.tempo.io/powerbiconnector/latest/how-to-fix-the-access-to-the-resource-is-forbidden

Regards,
Daniel