WEBVTT

00:00:00.080 --> 00:00:05.120
In this video I will show you how you can add a 
Visma.net Financials database and download data

00:00:05.120 --> 00:00:10.720
with the Power BI connector from Invantive Cloud. 
You do not need any technical knowledge to use

00:00:10.720 --> 00:00:17.520
our connector. This tutorial works for both 
PowerBI.com and Microsoft Power BI Desktop.

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

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

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

00:00:29.680 --> 00:00:33.040
Now select ‘Visma.net’ from the list of platforms.

00:00:34.560 --> 00:00:38.240
Sign into Visma.net Financials 
with your username and password.

00:00:41.040 --> 00:00:44.320
Allow Visma.net Intergrations 
to connect to your account.

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

00:00:51.440 --> 00:00:54.320
Click the orange ‘Add and save’ button.

00:00:54.320 --> 00:00:56.960
Now launch Microsoft Power BI.

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

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

00:01:07.280 --> 00:01:08.640
Click on ‘Connect’.

00:01:10.000 --> 00:01:15.840
Now go back to Invantive Cloud. Click 
the copy icon at ‘Bridge Online URL’.

00:01:15.840 --> 00:01:19.200
Paste the copied URL into the window in Power BI.

00:01:20.000 --> 00:01:21.680
Click on ‘OK’.

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

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

00:01:32.000 --> 00:01:34.880
Expand the first item. Here you can select your

00:01:34.880 --> 00:01:38.960
Visma.net tables with the data you 
want to use in Microsoft Power BI.

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

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

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

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

00:01:58.160 --> 00:02:03.760
If there are any changes to your Visma.net 
database, you can click on ‘Refresh’ at the top.

00:02:04.560 --> 00:02:09.360
This will refresh the data in your dashboard 
and reports and incorporate the latest changes.

00:02:10.160 --> 00:02:14.160
You can now use your Visma.net 
Financials database in Power BI.

00:02:14.800 --> 00:02:18.320
If you want to use a different data 
connector you can find more videos

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