Versions Compared

Old Version 2

changes.mady.by.user Nataliya Timoshina

Saved on

compared with

New Version Current

changes.mady.by.user Liliia Ostrovska

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents

How to create an Access Token

To export data from Jira to Microsoft Power BI in a secure way, you will need to create an Access Token. To create it, please follow the instructions in article How to create Access Token?

How to use the Access Token in Microsoft Power BI?

Copy the Data Source URL by clicking the Copy link icon.

Image Removed

In the Power BI Desktop, click Get Data → select OData feed, insert the copied Data Source link and click Ok

Image Removed

At the next step

  • Select Basic authentication

  • Enter your account email as a username.

  • Enter the Access Token into a Password field.

  • Click Connect

Image Removed
Tip

Please make sure that you have completed the previous two steps before proceeding.

  1. Create access token

  2. Create data source

  1. On the Data Source tab, select ↗ (the Open in Looker Studio icon).

Info

You will be redirected to the Looker Studio page.

looker-studio-ds-copy-link.gifImage Added

  1. Select the AUTHORIZE button.

If you are doing it for the first time or if you are not singed in to your Looker Studio account, Google will ask you to authorize.

Image Added

  1. Select your account.

Select the Use another account option if account you want to use is not listed.

Image Added

  1. Select Allow.

Info

Next to the Authorization section, the Credentials section will appear.

The AUTHORIZE button will become AUTORIZED, indicating that authorization was successful.

Image Added

  1. In the Username field, enter email you use with your Jira Cloud instance.

  2. In the Password field, enter your access token, and then select SUBMIT.

Info

The access token was created in this step.

Image Added
Info

After submit, you will see form with the Data Source URL and Table fields.

The Data Source URL field already contains URL of your data source as it was encrypted in your access token.

The Table field contains the drop-down list of tables available in this connector.

Image Added

  1. Select the table you want, and then select CONNECT.

Image Added
Info

You can also rename your data source by clicking on the Untitled Data Source field.

Image Added
Panel
panelIconId1f50e
panelIcon:mag_right:
panelIconText🔎
bgColor#C0B6F2

What’s the next step? Explore the Supported Apps section to discover additional possibilities to enrich your report.