Connecting to SQream Using Power BI Desktop¶
Power BI Desktop lets you connect to SQream and use underlying data as with other data sources in Power BI Desktop.
SQream integrates with Power BI Desktop to do the following:
Extract and transform your datasets into usable visual models in approximately one minute.
Use DAX functions (Data Analysis Expressions) to analyze your datasets.
Refresh datasets as needed or by using scheduled jobs.
SQream uses Power BI for extracting data sets using the following methods:
Direct query - Direct queries lets you connect easily with no errors, and refreshes Power BI artifacts, such as graphs and reports, in a considerable amount of time in relation to the time taken for queries to run using the SQream SQL CLI Reference guide.
Import - Lets you extract datasets from remote databases.
The Connect to SQream Using Power BI page describes the following:
To connect to SQream, the following must be installed:
ODBC data source administrator - 32 or 64, depending on your operating system. For Windows users, the ODBC data source administrator is embedded within the operating system.
SQream driver - The SQream application required for interacting with the ODBC according to the configuration specified in the ODBC administrator tool.
To install Power BI Desktop:
Download Power BI Desktop 64x.
Download and configure your ODBC driver.
For more information about configuring your ODBC driver, see ODBC.
Navigate to Windows > Documents and create a folder called Power BI Desktop Custom Connectors.
In the Power BI Desktop folder, create a folder called Custom Connectors.
From the Client Drivers page, download the PowerQuery.mez file.
Save the PowerQuery.mez file in the Custom Connectors folder you created in Step 3.
Open the Power BI application.
Navigate to File > Options and Settings > Option > Security > Data Extensions, and select (Not Recommended) Allow any extension to load without validation or warning.
Restart the Power BI Desktop application.
From the Get Data menu, select SQream.
Click Connect and provide the information shown in the following table:
Provide the network address to your database server. You can use a hostname or an IP address.
Provide the port that the database is responding to at the network address.
Provide the name of your database or the schema on your database server.
Provide a SQreamdb username.
Provide a password for your user.
Under Data Connectivity mode, select DirectQuery mode.
Provide your user name and password and click Connect.
SQream recommends using Power BI in the following ways for acquiring the best performance metrics:
Creating bar, pie, line, or plot charts when illustrating one or more columns.
Displaying trends and statuses using visual models.
Creating a unified view using PowerQuery to connect different data sources into a single dashboard.