> ## Documentation Index
> Fetch the complete documentation index at: https://docs.enterprise.emailmeter.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Power BI

> Create your own email analytics reports in Power BI

![](https://storage.googleapis.com/em-docs/enterprise-documentation/images/powerbi--cover.webp)

The [Power BI](https://www.microsoft.com/en-us/power-platform/products/power-bi) integration allows you to connect directly to your Email Meter data to create custom reports and dashboards using your email analytics data.

## Requirements

Before you can analyze Email Meter's data using Power BI, please make sure you have:

* Power BI Desktop installed on your computer
* A Google account
* A Google Cloud Platform project with billing enabled
* Access to your Email Meter dataset in [BigQuery](https://docs.enterprise.emailmeter.com/integrations/bigquery.md)

## Instructions

### Add the data source in Power BI

Launch the Power BI Desktop application in your computer, and click on the `Get data` option in the top menu bar.

![](https://storage.googleapis.com/em-docs/enterprise-documentation/images/powerbi--001.webp)

If this option isn't visible, go to `File > Get data` and click on `Get data to get started`.

![](https://storage.googleapis.com/em-docs/enterprise-documentation/images/powerbi--002.webp)

A modal will now open. Use the search bar to find `BigQuery`. Now, select `Google BigQuery` from the list and click on the `Connect` button.

![](https://storage.googleapis.com/em-docs/enterprise-documentation/images/powerbi--003.webp)

### Connect to BigQuery

Now, you will be prompted to `Sign in with Google`.

Just enter your email and password and confirm the connection when asked.

![](https://storage.googleapis.com/em-docs/enterprise-documentation/images/powerbi--004.webp)

### Choose your dataset

Once connected, you will see a list of the datasets and tables that you can access in BigQuery.

Find your Email Meter dataset, select it and click the `Load` button.

![](https://storage.googleapis.com/em-docs/enterprise-documentation/images/powerbi--006.webp)

When asked, choose `DirectQuery` as the connection method.

![](https://storage.googleapis.com/em-docs/enterprise-documentation/images/powerbi--005.webp)

### Create your Power BI report.

You can now design your custom Power BI report using Email Meter's data.

![](https://storage.googleapis.com/em-docs/enterprise-documentation/images/powerbi--007.webp)

We also offer a pre-built Power BI template that includes most of the common metrics and use case, so you can use it as a starting point to create your own report.

If you're interested in this, please reach out to your Business Intelligence Consultant for more information.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.