How to Export Data into Microsoft Power BI

Owned by Nataliya Timoshina
Last updated: Oct 14, 2024 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

 

How to Export Data into Microsoft Power BI Desktop

 

  1. Select Copy URL.

pbi-copy-url.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.

 

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

 

  1. Select Copy URL.

  1. Being signed in to your Microsoft Power BI Service (Online), + New, and then select Dataflow.

  1. Select the Define new tables option.

  1. Select the OData.

  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.

  5. Select Next.

  1. Select the tables to export, and then select Transform data.

  1. Perform the transformations you need, and then select Save & close.

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