How to Export Data into Microsoft Power BI
- Nataliya Timoshina
- Liliia Ostrovska
- Kateryna Bukhtiiarova ADMIN (Unlicensed)
- Liubov Topchyi
Please make sure that you have completed the previous two steps before proceeding.
How to Export Data into Microsoft Power BI Desktop
Select Copy URL.
Launch your Microsoft Power BI Desktop, select Get data, and then select OData.
In the URL field, paste the link of your data source, and then select OK.
Select the Basic authentication.
In the User name field, enter your email address associated with your Jira Cloud instance.
In the Password field, enter the access token you’ve created here.
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.
Select Connect.
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)
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:
In the URL* field, paste the link of your data source.
In the Authentication kind field, select Basic.
In the Username field, enter your email address associated with your Jira Cloud instance.
In the Password field, enter the access token you’ve created here.