/
How to Export Data into Microsoft Power BI

How to Export Data into Microsoft Power BI

Owned by Nataliya Timoshina
Last updated: Mar 13, 2025 by Liliia Ostrovska
3 min read

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

  1. Create access token

  2. Create data source

 

Without a Jira API token, the export may be limited to 10,000 users, and inactive users will not be included.

 

How to Export Data into Microsoft Power BI Desktop

 

  1. Select Copy URL.

pbi_connector_for_jira_tempo_-_export-step1.gif

 

 

  1. Launch your Microsoft Power BI Desktop, select Get data, and then select OData.

  1. In the URL field, paste the link of your data source, and then select OK.

  1. Select the Basic authentication.

  2. In the User name field, enter your email address associated with your Jira Cloud instance.

  3. In the Password field, enter the access token you’ve created here.

  1. Select which level to apply these settings to.

If you have several Jira instances and have installed Power BI Connector on each of them, we recommend selecting the lowest level.

In each of those Power BI Connectors, all data source URLs begin in the same way and they differ only in hash (the set of characters at the end of the link).

If you keep the highest level (default), you will experience an error, as in this case, Microsoft Power BI will try to use your credentials from one instance to all the others.

If you have only one instance, you can keep the default level.

 

  1. Select Connect.

 

  1. Select the tables you need, and then select Load.

If there is a large amount of data to import, it may take some time.

After the data is loaded, you can build graphs and dashboards based on the imported Jira data.

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

 

How to Export Data into Microsoft Power BI Service (Online)

 

If you have to use Power BI Service (Online), please refer to the Microsoft’s official documentation on how to set up your OData connection.

 

When it’s required to configure connection, please enter the following credentials:

  1. In the URL* field, paste the link of your data source.

  2. In the Authentication kind field, select Basic.

  3. In the Username field, enter your email address associated with your Jira Cloud instance.

  4. In the Password field, enter the access token you’ve created here.

 

Please refer to the screenshot as an example.

pbi-online-workspaces-basic.gif

To learn more on how to create and manage Power BI table relationships, please read our complete article

https://www.alphaservesp.com/blog/power-bi-data-modeling-why-to-create-power-bi-data-model

 

 

Related content