Send data to Microsoft Power BI

Note

This topic contains information about configuring a destination that sends query results to Microsoft Power BI using orchestrations. To configure a destination that sends audiences to Microsoft Power BI using campaigns see this topic .

Microsoft Power BI is a collection of software services, applications, and connectors that work together to turn unrelated sources of data into coherent, visually immersive, and interactive insights.

Important

Data is not sent from Amperity directly to Microsoft Power BI. Microsoft Power BI must connect to a location that supports queries to that data and cannot connect directly to a static file. Amperity must send data to Microsoft Power BI indirectly by configuring a destination to:

  1. Send a CSV file to an Azure container, after which it is picked up by Azure Synapse Analytics.

  2. Send a CSV file to Google Cloud Storage, after which it is transferred to Google BigQuery

  3. Send data directly to a Snowflake data warehouse.

Microsoft Power BI may be configured to connect directly to Snowflake, Google BigQuery, or Azure Synapse Analytics. The destination workflow in Amperity may be configured to send data on a regular basis to ensure that the data available to the Microsoft Power BI user is up to date.

Connect to Azure Synapse Analytics

Azure Synapse Analytics is a limitless analytics service and data warehouse. Azure Synapse Analytics has four components: SQL analytics, Apache Spark, hybrid data integration, and a unified user experience.

Amperity can be configured to send data to an Azure container, after which Azure Synapse Analytics can be configured to load that data. Microsoft Power BI can be configured to connect to Azure Synapse Analytics and use the Amperity output as a data source.

You may use the Azure Blob Storage container that comes with your Amperity tenant for the intermediate step (if your Amperity tenant is running on Azure). Or you may configure Amperity to send data to an Azure container that your organization manages directly.

To connect Microsoft Power BI to Azure Synapse Analytics

The steps required to configure Amperity to send data that is accessible to Microsoft Power BI from Azure Synapse Analytics requires completion of a series of short workflows, some of which must be done outside of Amperity.

Step 1.

Send CSV data to an Azure Blob Storage container from Amperity.

Step 2.

Load CSV data from Azure Blob Storage to Azure Synapse Analytics.

Step 3.

Connect Microsoft Power BI to an Azure Synapse Analytics workspac, and then access the data sent from Amperity.

Step 4.

Validate the workflow within Amperity and the data within Microsoft Power BI.

Step 5.

Configure Amperity to automate this workflow for a regular (daily) refresh of data.

Connect to Google BigQuery

Google BigQuery is a fully-managed data warehouse that provides scalable, cost-effective, serverless software that can perform fast analysis over petabytes of data and querying using ANSI SQL.

Amperity can be configured to send data to Google Cloud Storage, after which Google BigQuery can be configured to load that data. Power BI can be configured to connect to Google BigQuery and use the Amperity output as a data source.

You must configure Amperity to send data to a Cloud Storage bucket that your organization manages directly.

To connect Power BI to Google BigQuery

The steps required to configure Amperity to send data that is accessible to Power BI from Google BigQuery requires completion of a series of short workflows, some of which must be done outside of Amperity.

Step 1.

Send CSV data to Google Cloud Storage from Amperity.

Step 2.

Transfer data from Cloud Storage to Google BigQuery.

Step 3.

Connect Microsoft Power BI to Google BigQuery, and then access the data sent from Amperity.

Step 4.

Validate the workflow within Amperity and the data within Microsoft Power BI.

Step 5.

Configure Amperity to automate this workflow for a regular (daily) refresh of data.

Connect to Snowflake

Snowflake is an analytic data warehouse that is fast, easy to use, and flexible. Snowflake uses a SQL database engine that is designed for the cloud.

Amperity can be configured to share data (tables and/or entire databases) directly with Snowflake. Microsoft Power BI can be configured to connect to a Snowflake data warehouse and use that data as a data source.

To connect Microsoft Power BI to Snowflake

The steps required to configure Amperity to send data that is accessible to Microsoft Power BI from a Snowflake data warehouse requires completion of a series of short workflows, some of which must be done outside of Amperity.

Step 1.

Configure Snowflake to sync data using Amperity Bridge.

Step 3.

Connect Microsoft Power BI to Snowflake, and then access the data sent from Amperity. This connection may be from the Power BI Desktop or from the Power BI Service.

Note

The URL for the Snowflake data warehouse, the Snowflake username, the password, and the name of the Snowflake data warehouse are sent to the Microsoft Power BI user within a SnapPass link. Request this information from your Amperity representative prior to attempting to connect Microsoft Power BI to Snowflake.

Step 4.

Validate the workflow within Amperity and the data within Microsoft Power BI.

Step 5.

Configure Amperity to automate this workflow for a regular (daily) refresh of data.