Skip to main content

Varicent ELT Help Center

Microsoft Power BI

Abstract

Connect your Varicent ELT and Microsoft Power BI accounts to export your data to your Microsoft Power BI account.

Connect your Varicent ELT and Microsoft Power BI accounts to export your data to your Microsoft Power BI account. This connection allows Varicent ELT to write data to Microsoft Power BI.

Set up the connector to be available for use with the Export tool. You only need to set up the connection once. After the connection is set up, Varicent ELT can write updates and inserts into Microsoft Power BI.

Important

Microsoft Power BI has limitations on what you can push to the data set.

Create the connection

Create the connection between Varicent ELT and Microsoft Power BI. Generate a new Microsoft Power BI connection or use an existing one.

Warning

Microsoft has deprecated the real-time streaming feature on October 31, 2024, and any exports pointing to new datasets in Power BI will fail. Any pre-existing Power BI datasets exports will work as designed before until October 31, 2027.

Creating a new connection

  1. In Varicent ELT, go to your pipe.

  2. Add the Export tool.

  3. In the Export tool configuration section, click the Connection drop-down.

  4. From the connection drop-down, click + New connection.

  5. Create the new Microsoft Power BI connection for the Export tool.

  6. On the Connect to your Database page, enter the Connector name. Click Next.

    You are sent to the Microsoft Power BI website. Enter your Microsoft Power BI credentials and you are redirected back to Varicent ELT. You can now export data to Microsoft Power BI.

Using your existing Microsoft Power BI

  1. In Varicent ELT, go to your pipe.

  2. Add the Export tool.

  3. In the Export tool configuration section, click the Connection drop-down.

  4. Search for and select your existing Microsoft Power BI connection.

  5. Select the Workspace from the drop-down list.

  6. Enter a name for the export under the Data set name.

  7. Click Export now.

    Note

    The data is now available to use in the Export tool. For more information about the tool, see Export.

Error handling

The following errors may appear during the export process:

Error

Description

(error code: xxxx) message.

Export failed with a PowerBI error.