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:
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.
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.
See Webhook for the Data Stream overview and Insider One Webhook 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 includes example queries and engagement-analysis techniques you can adapt for the reports you build in Power BI or any other business-intelligence tool.