Connect with Power BI
On this page
You can create interactive dashboards and analysis reports from your SingleStoreDB cluster's data in Power BI.
Before connecting Power BI to SingleStoreDB, perform the following tasks.
Download and install the latest version of Power BI Desktop.
The SingleStore Direct Query connector only supports 64-bit versions of Power BI.
Download and install the latest version of The SingleStore ODBC Driver.
If you are using an older version of Power BI and the connector, see Upgrade the SingleStore Direct Query Connector.
You may need to update the Power BI reports after upgrading the connector.
The SingleStore Direct Query connector is included in the latest version of Power BI.
If you are using the SingleStore Power BI Bundle, uninstall it.
Ensure that the connector files are deleted from the machine. By default, the connector files are located in the
%USERPROFILE%\Documents\Power BI Desktop\Custom Connectorsfolder.
Download and install the latest version of The SingleStore ODBC Driver on the machines with Power BI Desktop and gateway.
If the same machine is running Power BI Desktop and acting as the gateway, download and install the SingleStore ODBC driver on this machine.
Update Power BI Desktop to version 2.
106. 883. 0 or later.
APPLICABLE OPEN SOURCE LICENSE: GNU LESSER GENERAL PUBLIC LICENSE Version 2.
IF YOU OR YOUR COMPANY DO NOT AGREE TO THESE TERMS AND CONDITIONS, DO NOT CHECK THE ACCEPTANCE BOX, AND DO NOT DOWNLOAD, ACCESS, COPY, INSTALL OR USE THE SOFTWARE OR THE SERVICES.
In this section
Last modified: February 6, 2023