Part One: Setting Up a HubSpot Connector in Tugger
This process presumes you have registered for Tugger and have signed in. (Sign Up Here)
After the signup process, navigate to My Connectors if you do not see the following; My Connectors will display all available options, until you have added those you require - failing that, select: Connectors.
Select the HubSpot Connector > 'Add Connector'.
At the next screen, you will need to enter information so Tugger knows what to call your Connector, as well as how much data (the date you wish to Tug data from) and how often it will be pulled (Tugged).
1. The name of HubSpot Connector, whatever makes sense to you.
2. How far back you wish to sync data from; note, the further back the more rows you will store.
3. How often you want to update your data.
4. As the image above shows, this is optional, but will provide additional functionality within the report.
Once you are happy with your entries, Authorise Access to HubSpot.
If you are not signed into HubSpot, you will be required to enter the log-in details; if you are already signed into HubSpot in the same browser as your Tugger account, then this step will be skipped.
Note: Admin rights are required on your HubSpot account.
After signing in to HubSpot, as above (presuming you needed to), you should see a request to choose the account, which (to continue) you will need to do.
Select the account, then click on the Choose Account.
Note: If you chose to include the optional data (at the 'Add Your HubSpot Connector' stage above) the obscured numbers above will be required later, when importing your data into Power BI Desktop; this number is also available in your HubSpot URL.
The following screen, when it appears, only remains visible for a moment; should it require a response (to continue) you need to click on the 'tick' option.
Once done you should be returned to Tugger.
Which after a few moments should update to advise that it's Tugging.
Note: As the first sync of data can take anything from minutes to hours, depending on the size of your data-set, it is fine if you need to close the tab.
Once the data from your HubSpot account has been synced over, on the Summary page (highlighted below) the Tug Successful, will show: Yes; in addition, the Tug Status will also update.
Note: You will not be able to continue until this has completed.
You will notice that the time to next sync is 48 minutes, which is dependent on what you selected earlier. If you wish to change how often the syncing occurs, select the Settings shown above.
To continue with importing a report template into Power BI Desktop, please read on.
Part Two: Import your HubSpot data into Power BI Desktop
… Close the Splash Screen.
Navigate to File > Import > Select: Power BI Template
Locate the report templates (.pbit extension) previously downloaded.
… Select one, and open.
Tugger’s Report Credentials Page (displayed again for clarity)
Regardless of what method you use to import the template, you will be presented with the following screen, once it has loaded/imported.
From the Report Credentials page above, copy the OData URL (1 in the above image) into the Tugger URL in the image below.
2. If the report you are loading displays this, as discussed earlier, the number can be obtained from your HubSpot URL (once logged in; see the Cut-Out section in the image above).
It should be noted that not all reports will have this option.
... And Load when ready.
If this is the first time you have loaded a report, you will be asked to enter authentication details; see Setting Up Your Reports For The First Time in Power BI Desktop, which contains more detailed information, although it is shown briefly below.
A Refresh pop-up dialogue appears:
This will update with values for the tables: bytes, Kbytes and Mbytes are usual, but will depend on the amount of data you have.
… After a few moments, an OData feed dialogue appears.
Note: If an error occurs after clicking Connect, see, Report Refresh Error.
There will be several tabs available...
… Highlighted at the bottom of the image is the open tab, and the tab-navigation buttons (forward and backward) for when there are tabs off-screen.
You may wish to just save the report at this stage, for example if you’re stopping now with a view to continuing later. It forms part of the Publishing Process, which follows this section, if you are continuing straight away, just give it a name that makes sense to you.
File > Save As
… Save to a directory of your choice.
Part Three: Publish your HubSpot Data to Power BI Service (online)
Pre-requisites for this part of the process are:
- Power BI Service: setup (ideally, Workspaces and Access (permissions) added for Users as appropriate).
- Power BI Desktop report imported.
Please see the Power BI Online Workspaces and Users article for basic information relating to adding Workspaces and Users, including assigning the level of access users need.
We do recommend setting up Workspaces beforehand as although the report can be saved to a new Work Space later, it doesn’t copy all the components (no dataset - compare 1 and 2 below) when published, only the report. Not only this, but reports added to the default Workspaces level cannot be shared via assigning Access.
This may not be an issue, but those assigned to a Workspace without a Dataset cannot refresh it, and will have to rely on the automated refresh, unless they can get it manually refreshed by another user.
Select Publish, 1 in the above image.
If you haven’t already saved, then 2 will appear (and can even after saving).
… Save (3) to a directory of your choice.
If you have already saved, after clicking ‘Publish’, the Publish to Power BI dialogue should appear, otherwise it appears after saving.
The steps are:
Note: If the only Workspace is called My Workspace (which is the default and always available) you may wish to Cancel instead of clicking Select. You could then create a Workspace - perhaps configuring access for Users at the same time (Available here: Power BI Online Workspaces and Users.). After creating a Workspace: Publish again to the newly created Workspace.
Once the report has been published, the following should be displayed.
Navigate to Power BI online to find your report or click on the link available in the dialogue shown in the image above.
Part Four: Navigating to a Published Document in Power BI Online
After logging into Power BI Online, to navigate to your previously published report: see image below.
In the example here: Workspaces > HubSpot, as the image displays; the optional search feature is also indicated.
Note: this report contains only limited dummy data.
After selecting the report, or if following the link from Power BI desktop, the report (example shown below) is displayed.