WEBVTT

00:00:00.080 --> 00:00:05.760
In this video I will show you how you can add an 
JIRA database and import JIRA data into Power BI

00:00:05.760 --> 00:00:11.440
using the JIRA Power BI connector from Invantive 
Cloud. You do not need any technical knowledge

00:00:11.440 --> 00:00:18.160
to use our connector. This tutorial works for 
both PowerBI.com and Microsoft Power BI Desktop.

00:00:18.800 --> 00:00:22.800
Don't have an account on Invantive 
Cloud yet? Then watch our video on

00:00:22.800 --> 00:00:26.000
how to create an account for a free 180-day trial.

00:00:26.800 --> 00:00:30.560
Press the ‘Add Database’ button on 
the homepage of Invantive Cloud.

00:00:31.440 --> 00:00:34.800
Now select the ‘Atlassian’ group 
from the list of platforms.

00:00:35.680 --> 00:00:36.880
Click on ‘JIRA’.

00:00:38.080 --> 00:00:44.160
Allow the Power BI connector for JIRA to access 
your Atlassian account so you can link your data.

00:00:44.160 --> 00:00:46.480
Also select your desired JIRA site.

00:00:48.160 --> 00:00:53.120
Your IP address must be added so that 
you can use Bridge Online with Power BI.

00:00:53.120 --> 00:00:55.520
Click the orange ‘Add and Save’ button.

00:00:56.400 --> 00:00:59.600
Now launch Microsoft Power BI Desktop.

00:00:59.600 --> 00:01:02.720
Select ‘Get data’ under the ‘Home’ tab.

00:01:02.720 --> 00:01:07.520
Look for the default ‘OData feed’ connector 
in the list of Power BI connectors.

00:01:08.400 --> 00:01:09.760
Click on ‘Connect’.

00:01:11.360 --> 00:01:17.120
Now go back to Invantive Cloud. Click the 
copy icon next to ‘Bridge Online URL’.

00:01:17.920 --> 00:01:21.200
Paste the copied URL into the window in Power BI.

00:01:22.000 --> 00:01:23.200
Click on ‘OK’.

00:01:24.800 --> 00:01:29.680
You must now log in with your Invantive 
Cloud credentials. Click on ‘Basic’.

00:01:30.240 --> 00:01:35.120
Enter your Invantive Cloud email address 
and password. Then press ‘Connect’.

00:01:37.360 --> 00:01:40.560
Expand the list of tables. Here you can select the

00:01:40.560 --> 00:01:44.160
tables with JIRA data you want 
to use in Microsoft Power BI.

00:01:44.880 --> 00:01:48.240
When you’ve made your selection, click on ‘Load’.

00:01:48.240 --> 00:01:51.680
Depending on the JIRA data 
volume, this may take some time.

00:01:52.480 --> 00:01:57.440
After the download is complete, you will see 
an overview of all imported tables with JIRA

00:01:57.440 --> 00:02:03.120
data on the right. You can check a table to 
use for dashboards and reports in Power BI.

00:02:07.440 --> 00:02:10.640
If there are any changes to 
your JIRA Cloud database,

00:02:10.640 --> 00:02:14.880
you can click on ‘Refresh’ at the 
top. This will refresh the data in

00:02:14.880 --> 00:02:18.800
your Power BI dashboard and reports 
and implement the latest changes.

00:02:19.520 --> 00:02:22.960
You can now use your JIRA 
Cloud database in Power BI.

00:02:23.680 --> 00:02:27.440
If you want to use a different Power 
BI connector you can find more videos

00:02:27.440 --> 00:02:31.360
on our YouTube channel showing you 
how to use our other connectors.