WEBVTT

00:00:00.080 --> 00:00:04.640
In this video I will show you how you can add 
a Twinfield database and download Twinfield

00:00:04.640 --> 00:00:08.880
data into Power BI using the Power 
BI connector from Invantive Cloud.

00:00:09.440 --> 00:00:13.600
You do not need any technical knowledge 
to use our Twinfield connector.

00:00:13.600 --> 00:00:18.880
This tutorial works for both PowerBI.com 
and Microsoft Power BI Desktop.

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

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

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

00:00:32.080 --> 00:00:35.280
Now select ‘Twinfield’ from the list of platforms.

00:00:36.960 --> 00:00:43.840
Log in to Twinfield with your 
username, password and organisation.

00:00:44.720 --> 00:00:49.600
Allow Invantive Cloud to access your 
Twinfield data by pressing ‘Yes, Allow’.

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

00:00:56.000 --> 00:00:58.480
Click the orange ‘Add and Save’ button.

00:00:59.520 --> 00:01:02.320
Now launch Microsoft Power BI Desktop.

00:01:03.360 --> 00:01:06.320
Select ‘Get data’ under the ‘Start’ tab.

00:01:07.120 --> 00:01:12.000
Look for the standard ‘OData feed’ connector 
in the list of Power BI connectors.

00:01:13.360 --> 00:01:14.720
Click on ‘Connect’.

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

00:01:22.560 --> 00:01:25.840
Paste the copied URL into the window in Power BI.

00:01:26.640 --> 00:01:27.840
Click on ‘OK’.

00:01:28.560 --> 00:01:32.960
Now log in with your Invantive 
Cloud credentials. Click on ‘Basic’.

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

00:01:39.760 --> 00:01:41.920
Expand the list in Power BI.

00:01:41.920 --> 00:01:47.200
Here you can select your Twinfield tables with 
the data you want to use in Microsoft Power BI.

00:01:47.200 --> 00:01:51.280
Click on ‘Load’ when you’ve made your 
selection from the Twinfield tables.

00:01:52.080 --> 00:01:55.360
Depending on the size of the 
tables, this may take some time.

00:01:56.640 --> 00:02:01.680
After the download is complete, you will see 
an overview of all loaded Twinfield tables on

00:02:01.680 --> 00:02:07.840
the right. You can check a table to use 
for dashboards and reports in Power BI.

00:02:11.840 --> 00:02:16.000
If there are any changes to your 
Twinfield database, you can click on

00:02:16.000 --> 00:02:19.200
‘Refresh’ at the top. This will refresh the data

00:02:19.200 --> 00:02:23.440
in your Power BI dashboard and reports 
and incorporate the latest changes.

00:02:24.080 --> 00:02:29.760
You can now use your Twinfield database in Power 
BI. If you want to use a different data connector

00:02:29.760 --> 00:02:35.600
you can find more videos on our YouTube channel 
showing you how to use other Power BI connectors.