EventBuilder Connectors for Power BI
Last updated: March 2, 2021
EventBuilder offers two custom connector options for Administrators and Organizers to harness the power of their Event data and bring it to life with Microsoft's data visualization tool: Power BI.
The free version of EventBuilder's Power BI connector provides Organizers with Event-level data, including number of Events, number of Registrants, number of Attendees, etc, for export to Power BI. Once exported, Organizers can use Event data in Power BI to create dashboards and other visualization tools.
In addition to Event-level data, our Deluxe Power BI Connector gives Administrators and Organizers access to Registrant data, including collected demographics, registration question responses, poll responses, and other valuable Registrant information.
The Deluxe Connector is $249 per month (20% discount for annual purchase.)
To purchase and request the Deluxe Connector to be added to your Portal, you must email firstname.lastname@example.org and indicate which account on your Portal will be used for the Power BI connection. If you would like all activity on your Portal imported to Power BI, please indicate an Administrator account for the connection.
EventBuilder must issue an API Key and Secret for users who have 2-Factor Authentication configured and enabled on their portal, and/or need to provide access to a Power BI specialist without an EventBuilder subscription.
To obtain the API Key and Secret, contact email@example.com
Note: you must download and configure Microsoft Power BI for Desktop before starting this step.
Click here to download the EventBuilder custom connector. Save in the location of your choice:
The connector is an executable file. Once downloaded, double click to run the program and install it to your machine.
The following dialog will appear. Choose either "Free" or "Deluxe" as applicable.
You will get a notification once the Connector is installed:
Next, open Power BI desktop client.
Click on 'Get Data' in the upper left corner.
Search for and select 'EventBuilder' as your data source and select Connect.
You will be presented with a pop up window where you can select which dataset you would like as well as apply any query parameters you prefer (optional). Click OK.
Login with your EventBuilder Portal username and password and connect.
Your data will be automatically imported into Power BI for you.