WEBVTT

00:00:00.080 --> 00:00:05.440
In this video I will show you how you can add a 
Discourse database and download data into Power BI

00:00:05.440 --> 00:00:10.240
using the connector from Invantive Cloud. You 
do not need any technical knowledge to use

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

00:00:17.360 --> 00:00:20.080
Don't have an account on Invantive Cloud yet?

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

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

00:00:29.920 --> 00:00:32.880
Now select ‘Discourse’ from the list of platforms.

00:00:33.520 --> 00:00:39.200
Enter your Discourse server name, username 
and API key. You can register an API key

00:00:39.200 --> 00:00:44.080
on your Discourse site slash 
admin, slash api, slash keys.

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

00:00:49.200 --> 00:00:51.520
Click the orange ‘Add and Save’ button.

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

00:00:54.960 --> 00:00:58.080
Select ‘Get data’ under the ‘Home’ tab.

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

00:01:03.680 --> 00:01:05.040
Click on ‘Connect’.

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

00:01:11.760 --> 00:01:15.120
Paste the copied URL into the window in Power BI.

00:01:15.840 --> 00:01:17.040
Click on ‘OK’.

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

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

00:01:30.000 --> 00:01:32.720
Expand the first item. Here you can select your

00:01:32.720 --> 00:01:36.560
Discourse tables with the data you 
want to use in Microsoft Power BI.

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

00:01:41.040 --> 00:01:44.800
Depending on the size of the Discourse 
tables, this may take some time.

00:01:45.600 --> 00:01:50.640
After the download is complete, you will see an 
overview of all Discourse tables on the right.

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

00:01:57.760 --> 00:02:01.840
If there are any changes to your 
Discourse database, you can click on

00:02:01.840 --> 00:02:06.000
‘Refresh’ at the top. This will 
refresh the data in your Power

00:02:06.000 --> 00:02:09.440
BI dashboard and reports and 
implement the latest changes.

00:02:10.240 --> 00:02:13.680
You can now use your Discourse 
database in Power BI.

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

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