
Prerequisites
Before connecting Power BI to Firebolt, ensure you have:- Power BI Desktop – Download and install from the Power BI Desktop download page.
- Firebolt account – An active Firebolt account. If you don’t have one, sign up.
- Firebolt database and table – A Firebolt database with data ready for visualization. If needed, create a database and load data into it.
- Firebolt service account – An active Firebolt service account with its ID and secret.
- Firebolt user – A user associated with your service account, having USAGE permission to query your database and OPERATE permission to start and stop an engine.
Install the Firebolt ODBC driver
- Download the ODBC driver for your system architecture Windows x64 or Windows x32/x86.
- Run the installer and follow the prompts to complete the installation.
Install the Firebolt Power BI Connector
Option 1: Using the signed connector (Recommended)
Follow these instructions if you have administrator access to your computer or are able to modify the registry. This is the most secure way. Otherwise, follow the unsigned guide below.- Download the latest Firebolt Power BI connector (
Firebolt.pqx
) from the Firebolt Power BI Connector GitHub repository. - Place the downloaded
.pqx
file into theDocuments\Power BI Desktop\Custom Connectors
directory in your Windows operating system. If the folder does not exist - create it. - Open the registry editor from the Start menu or by pressing Windows + R, typing
regedit
and pressing enter. - Navigate to
HKEY_LOCAL_MACHINE\Software\Policies\Microsoft\Power BI Desktop
, creating the path if it does not exist. - Add a new value under this path. The type should be
Multi-String Value: REG_MULTI_SZ
. It should be calledTrustedCertificateThumbprints
. - Right-click the key, then select Modify and add the following value -
C838876B92BB2C62AB228A6DFDEF24F72CA46193
. - Save the value.
Option 2: Using the unsigned connector
Suitable if you don’t have access to the Windows registry. Requires Power BI security settings modification. Only use if following the steps above is not possible.- Download the latest Firebolt Power BI connector (
Firebolt.mez
) from the Firebolt Power BI Connector GitHub repository. - Place the downloaded
.mez
file into theDocuments\Power BI Desktop\Custom Connectors
directory in your Windows operating system. If the folder does not exist - create it. - Restart Power BI Desktop to ensure the connector is loaded correctly.
- In Power BI Desktop, go to File > Options and settings > Options > Security, and under Data Extensions, select Allow any extension to load without validation or warning. Click OK to apply the changes. (This step is necessary because custom connectors are not signed by Microsoft and Power BI Desktop blocks unsigned connectors by default for security reasons.)
Configure the Firebolt connection in Power BI
- Open Power BI Desktop.
- Select Get data from the Home ribbon.
- Search for and select Firebolt from the list of available data sources.
-
In the first stage of the connection setup, enter the following parameters:
- Account: The name of your Firebolt account.
- Database: The name of the Firebolt database you want to connect to.
- Engine Name: The name of the Firebolt engine to run queries.
- Data Connectivity Mode: Choose between Import or DirectQuery mode based on your use case:
- Import Mode: Data is imported into Power BI and stored in-memory for faster performance. This mode is ideal for smaller datasets or scenarios where real-time updates are not required.
- DirectQuery Mode: Queries are sent directly to Firebolt in real-time, ensuring that the latest data is always used. This mode is suitable for large datasets or when up-to-date data is critical.
-
In the second stage, enter your Firebolt credentials:
- Client ID: The ID of your Firebolt service account.
- Client Secret: The secret for your Firebolt service account.
- Once connected, you will see a list of available tables in the Navigator pane. Select the tables you want to visualize and click Load to import the data into Power BI.
Select and visualize data in Power BI
After connecting successfully, you can select and visualize data from Firebolt:- In the Navigator pane, select the tables you want to visualize.
- Click Load to import data into Power BI.
- Once loaded, use Power BI’s visualization tools to create charts and dashboards. For more information, see Power BI’s Create reports documentation.
Limitations
- The Firebolt ODBC driver currently supports Power BI Desktop only. Power BI Service (cloud) is not supported.
- Changing the database or engine requires creating a new ODBC connection.
Additional resources
- Power BI documentation.
- Power BI Community for support and best practices.