Microsoft Power BI Custom Data Connectors

This is a repository of custom data connectors to Power BI developed by team at bigintsolutions.com

Available custom data connectors

• HubSpot
• Zendesk Support Tickets

Need further support?

If you need custom integrations or custom Fabric or Power BI development solutions, then feel free to reach us at bigintsolutions.com/contact or send me an email (my email id is in the profile section).

The HubSpot Connector

The most requested data connector is here! Connect to HubSpot data and visualize your sales pipeline funnel, deal owner performance, win rate and many more metrics.

Note: When creating a private app on HubSpot ensure following scopes are added:

Release

Mar 2025

• Support added for Hubspot private apps
• The current version on GitHub supports 100 rows for each object
• Objects available
  • Accounts
  • Contacts
  • Deals
  • Tickets
  • Owners
• Please contact me if you need support for more than 100 rows or support for additional objects

I'm excited, how do I get started?

Step 1: Get HubSpot Private App token for your account

Get HubSpot Token here

Step 2: Download HubSpot.mez file from HubSpot\build folder in this repository

Step 3: Copy this file under C:\Users\<Your_User_Name>\Documents\Microsoft Power BI Desktop\Custom Connectors

*If the folders do not exist, create them

Step 4: Open Power BI Desktop, set "(Not recommended) Allow any..." under Options/Data Extensions

Step 5: Restart Power BI Desktop, navigate to "Get Data" -> "More..." -> "Online Services" and you will find "HubSpot (Beta)), select it.

Step 6: Input Key of your HubSpot Account

Step 7: You can now select objects from your HubSpot account

After you have imported the data, you can create a stunning view of the data like this:

The Zendesk Support Tickets Connector

Extremely useful connector to fetch Zendesk Support views and tickets information from Zendesk. The connector uses OAuth 2.0 to access your Zendesk's account data.

Setup

1. Register an OAuth 2.0 client.

Make sure to provide "redirect_url" as https://oauth.powerbi.com/views/oauthredirect.html

Read more here

See screenshot below for quick navigation

2. Grab client id and secret

Client Id is nothing but the unique identifier.

3. Download the .mez file from ZendeskSupport\build folder from this repo

4. Rename ZendeskSupport.mez to ZendeskSupport.zip

5. Unzip the contents, and edit config.json in Notepad or any text editor

6. Replace your_client_id and your_client_secret with your apps client_id and client_secret

7. Save the file, and zip the contents again. Please make sure you select all content (Ctrl+A), right click and send to Compressed (zipped) folder.

8. Rename the zip back to .mez

9. Copy this to %USERPROFILE%\Documents\Microsoft Power BI Desktop\Custom Connectors

Note: Create folders if they do not exist.

10. Open Power BI Desktop, set "(Not recommended) Allow any..." under Options/Data Extensions

11. Restart Power BI Desktop, navigate to "Get Data" -> "More..." -> "Online Services" and you will find "Zendesk Support (Beta)), select it.

12. Provide your Zendesk account full URL and follow along.

If everything is set correctly, then you will see a list of all active views. You can select whatever views you want data for.

And visualize it something like this:

Questions/Issues?

Please open an issue on GitHub. I will connect with you on the issue.