WEBVTT

00:00:00.140 --> 00:00:04.360
In this video I will show you how you can
add an Teamleader database and download data

00:00:04.360 --> 00:00:07.660
with the Power BI connector from Invantive
Cloud.

00:00:07.660 --> 00:00:11.100
You do not need any technical knowledge to
use our connector.

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

00:00:16.800 --> 00:00:19.689
Don't have an account on Invantive Cloud yet?

00:00:19.689 --> 00:00:25.000
Then watch our video on how to create an account
for a free 180-day trial.

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

00:00:29.460 --> 00:00:32.949
Now select ‘Teamleader’ from the list
of platforms.

00:00:32.949 --> 00:00:37.040
Log in with your Teamleader credentials.

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

00:00:42.250 --> 00:00:45.059
Click the orange ‘Add and save’ button.

00:00:45.059 --> 00:00:48.620
Now launch Microsoft Power BI.

00:00:48.620 --> 00:00:52.070
Select ‘Get data’ under the ‘Home’
tab.

00:00:52.070 --> 00:00:57.219
Look for the standard ‘OData Feed’ connector
in the list of Power BI connectors.

00:00:57.219 --> 00:01:00.180
Click on ‘Connect’.

00:01:00.180 --> 00:01:02.609
Now go back to Invantive Cloud.

00:01:02.609 --> 00:01:06.360
Click the copy icon at ‘Bridge Online URL'.

00:01:06.360 --> 00:01:10.049
Paste the copied URL into the window in Power
BI.

00:01:10.049 --> 00:01:13.180
Click on ‘OK’.

00:01:13.180 --> 00:01:16.820
You must now log in with your Invantive Cloud
credentials.

00:01:16.820 --> 00:01:18.880
Click on ‘Basic’.

00:01:18.880 --> 00:01:25.400
Enter your Invantive Cloud email address and
password and then press ‘Connect’.

00:01:25.400 --> 00:01:26.979
Expand the first item.

00:01:26.979 --> 00:01:31.149
Here you can select your Teamleader tables
with the data you want to use in Microsoft

00:01:31.149 --> 00:01:32.630
Power BI.

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

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

00:01:39.479 --> 00:01:45.619
After the download is complete, you will see
an overview of all your tables on the right.

00:01:45.619 --> 00:01:50.740
You can check a table to use for dashboards
and reports in Power BI.

00:01:50.740 --> 00:01:56.150
If there are any changes to your Teamleader
database, you can click on 'Refresh' at the

00:01:56.150 --> 00:01:57.159
top.

00:01:57.159 --> 00:02:02.500
This will refresh the data in your dashboard
and reports and incorporate the latest changes.

00:02:02.500 --> 00:02:05.899
You can now use your Teamleader database in
Power BI.

00:02:05.899 --> 00:02:10.479
If you want to use a different data connector
you can find more videos on our YouTube channel

00:02:10.479 --> 00:02:12.690
showing you how to use our other connectors.