Connect to SQream Using Power BI Desktop

Overview

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 /v2020.3.1/isual 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:

Prerequisites

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 dri/v2020.3.1/er - The SQream application required for interacting with the ODBC according to the configuration specified in the ODBC administrator tool.

Installing Power BI Desktop

To install Power BI Desktop:

  1. Download Power BI Desktop 64x.

  2. Download and configure your ODBC dri/v2020.3.1/er.

    For more information about configuring your ODBC dri/v2020.3.1/er, see ODBC.

  3. Na/v2020.3.1/igate to Windows > Documents and create a folder called Power BI Desktop Custom Connectors.

  4. In the Power BI Desktop folder, create a folder called Custom Connectors.

  5. From the Client Dri/v2020.3.1/ers page, download the PowerQuery.mez file.

  1. Sa/v2020.3.1/e the PowerQuery.mez file in the Custom Connectors folder you created in Step 3.

  2. Open the Power BI application.

  3. Na/v2020.3.1/igate to File > Options and Settings > Option > Security > Data Extensions, and select (Not Recommended) Allow any extension to load without /v2020.3.1/alidation or warning.

  4. Restart the Power BI Desktop application.

  5. From the Get Data menu, select SQream.

  6. Click Connect and pro/v2020.3.1/ide the information shown in the following table:

Element Name

Description

Ser/v2020.3.1/er

Pro/v2020.3.1/ide the network address to your database ser/v2020.3.1/er. You can use a hostname or an IP address.

Port

Pro/v2020.3.1/ide the port that the database is responding to at the network address.

Database

Pro/v2020.3.1/ide the name of your database or the schema on your database ser/v2020.3.1/er.

User

Pro/v2020.3.1/ide a SQreamdb username.

Passwords

Pro/v2020.3.1/ide a password for your user.

  1. Under Data Connecti/v2020.3.1/ity mode, select DirectQuery mode.

  2. Click Connect.

  3. Pro/v2020.3.1/ide your user name and password and click Connect.

Best Practices for Power BI

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 /v2020.3.1/isual models.

  • Creating a unified /v2020.3.1/iew using PowerQuery to connect different data sources into a single dashboard.

Supported SQream Dri/v2020.3.1/er /v2020.3.1/ersions

SQream supports the following SQream dri/v2020.3.1/er /v2020.3.1/ersions:

  • The PowerQuery Connector is an additional layer on top of the ODBC.

  • SQream Dri/v2020.3.1/er Installation (ODBC /v2020.3.1/4.1.1) - Contact your administrator for the link to download ODBC /v2020.3.1/4.1.1.