--- title: "Analyze Insider One Data in Power BI" slug: "analyze-insider-one-data-in-power-bi" description: "Covers connecting Power BI to Insider One data via Snowflake, S3, GCS, or Azure Blob Storage exports, plus a real-time Webhook streaming alternative." updated: 2026-07-27T12:52:56Z published: 2026-07-27T12:52:56Z canonical: "academy.insiderone.com/analyze-insider-one-data-in-power-bi" --- > ## Documentation Index > Fetch the complete documentation index at: https://academy.insiderone.com/llms.txt > Use this file to discover all available pages before exploring further. # Analyze Insider One Data in Power BI You can analyze your Insider One data in Power BI by making it available in your own data warehouse or cloud storage and connecting Power BI to that destination. Insider One shares or delivers your selected events and attributes on a schedule you control, and Power BI reads them from your destination like any other data source. This guide helps you choose the right destination and walks you through both sides of the flow. ## Requirements Before you begin, ensure the following prerequisites are met: - To set up integrations on the External Platform Integrations screen of the InOne panel, you need an **Administrator** or an **Editor with PII access** role (PII: personally identifiable information). - You have a supported destination: a **Snowflake account**, or a cloud storage bucket you own (**Amazon S3**, **Google Cloud Storage**, or **Azure Blob Storage**). **Amazon Redshift** and **Databricks** are reached through a bucket export plus your own ingestion pipeline. - Your Power BI environment can reach that destination. Power BI includes **Get Data** connectors for **Snowflake**, **Amazon Redshift**, and **Databricks**. - Decide which events and attributes you want to export for analysis. ## Choose your destination | Destination | How your data arrives | How Power BI reads it | | --- | --- | --- | | **Snowflake** | Insider One shares your data through **Snowflake Secure Data Sharing**. No copy is loaded into your account, and shared data does not add to your storage costs. | Power BI connects to your Snowflake account, where the shared data is available | | **Amazon S3, Google Cloud Storage, Azure Blob Storage** | Scheduled exports deliver CSV (comma-separated values) files to a bucket or container you own | Your data pipeline loads the files into a database or warehouse that Power BI reads | | **Amazon Redshift, Databricks** | Built on a bucket export: Insider One delivers CSV files to your bucket, and your own ingestion pipeline (for example, COPY or Auto Loader) loads them into the warehouse | Power BI connects directly with its built-in connector for that warehouse | ## Step 1: Make Your Data Available in Your Destination Set up the export in Insider One: - In the InOne panel, navigate to **Components** > **Integrations** > **External Platform Integrations** and create the integration for your destination: **Snowflake**, **Amazon S3**, **Google Cloud Storage**, or **Azure Blob Storage**. - Complete the destination-specific setup. For bucket destinations, authenticate with your storage credentials and select the **events and attributes** you want to export. For Snowflake, enter your **Snowflake Account ID** and use the share details provided by Insider One; the Insider One team approves the data-sharing request. - In the Launch step, set the sync frequency (for Snowflake, the **Sync Period**, with intervals up to 24 hours) and activate the integration. To land the data in **Amazon Redshift** or **Databricks**, export to a bucket first and load the files with your own ingestion pipeline. The destination guides cover each pattern end to end: - [Export Data to Snowflake from Insider One](https://academy.insiderone.com/docs/export-data-to-snowflake-from-insider-one) - [Export Data to Amazon S3](https://academy.insiderone.com/docs/export-data-to-amazon-s3) - [Export Data to Google Cloud Storage](https://academy.insiderone.com/docs/export-data-to-google-cloud-storage) - [Export Data from Insider One to Azure Blob Storage](https://academy.insiderone.com/docs/export-data-from-insider-one-to-azure-blob-storage) - [Export Data from Insider One to Amazon Redshift](https://academy.insiderone.com/docs/export-data-from-insider-one-to-amazon-redshift) - [Export Data from Insider One to Databricks](https://academy.insiderone.com/docs/export-data-from-insider-one-to-databricks) ## Step 2: Connect Power BI to Your Destination Once your data is flowing, connect Power BI on your side: - In Power BI, use **Get Data** and choose the connector for your warehouse, for example, **Snowflake**, **Amazon Redshift**, or **Databricks**. - Enter your warehouse connection details and select the tables that hold your Insider One data. For Snowflake, these are in the database shared by Insider One. - Build your reports and dashboards on that data, and refresh your dataset as new scheduled exports arrive. > [!NOTE] > If you export to cloud storage and do not use a warehouse, load the delivered CSV files into a database first, then connect Power BI to it. ## Real-Time Alternative: Stream Data with Webhooks The warehouse path above is built for reporting and analysis. If you also need data the moment it changes, Webhook (Data Stream) transmits events and attributes to an endpoint you own in real time: the **Attribute Stream** sends a webhook whenever a monitored user attribute changes, and the **Event Stream** sends a webhook as tracked events occur. You can define custom headers and a custom payload for your endpoint, and your integration can forward the incoming data to your BI tool's real-time input. > [!NOTE] > See [Webhook](https://academy.insiderone.com/docs/external-platform-integrations-webhook) for the Data Stream overview and [Insider One Webhook](https://academy.insiderone.com/docs/insider-webhook-configuration) for configuration, including payload customization, security, and testing. ## Example Analyses If you use the Snowflake destination, [Best Practices for Insider One Engagement Data in Snowflake](https://academy.insiderone.com/docs/best-practices-for-insider-one-engagement-data-in-snowflake) includes example queries and engagement-analysis techniques you can adapt for the reports you build in Power BI or any other business-intelligence tool. ## Related - [Export Data to Snowflake from Insider One](/export-data-to-snowflake-from-insider-one.md) - [Export Data to Amazon S3](/export-data-to-amazon-s3.md) - [Export Data to Google Cloud Storage](/export-data-to-google-cloud-storage.md) - [Export Data from Insider One to Azure Blob Storage](/export-data-from-insider-one-to-azure-blob-storage.md) - [Export Data from Insider One to Amazon Redshift](/export-data-from-insider-one-to-amazon-redshift.md) - [Export Data from Insider One to Databricks](/export-data-from-insider-one-to-databricks.md) - [Best Practices for Insider One Engagement Data in Snowflake](/best-practices-for-insider-one-engagement-data-in-snowflake.md)