This page describes how to setup [Microsoft Power BI](🔗) and configure it for use with Rockset.

## Setup

Setting up a Power BI reporting instance on-premise can be done using the [Power BI Report Server](🔗), and can be accessed using [Power BI Desktop](🔗) or [Power BI Mobile](🔗). Microsoft's website has excellent documentation on each of these approaches, and downloads for each of their Power BI products can be found [here](🔗).

## Configuration

To configure Rockset with Power BI, we will need to create a Query Lambda use the [Rockset Python SDK](🔗) to create a Python script in Power BI:

  1. **Get Rockset credentials.** Create and save an API Key using the [API Key tab of the Rockset Console](🔗).

Create New API Key

  1. **Create visualization query.** [Create a <<glossary:Query Lambda>>](🔗) in Rockset with the data you would like to visualize using Power BI.

Create New Query Lambda

  1. **Create Python script.** Next, we will create a Python script in Power BI with your Rockset Query Lambda:

    • Set up the Power BI Python integration by following the instructions [here](🔗).

    • Install the Rockset Python SDK by following instructions [here](🔗).

    • Prepare a Python script using the Power BI Python integration and the Rockset Python SDK by following the instructions [here](🔗), using the results from your Query Lambda execution response as the input data.

    • Save your newly created Python script and import the data into Power BI

Using our example from above, your Python script might look something like this:

## Usage

To visualize your Rockset data inside Power BI, you can simply create a Power BI visual using the Python script we created above by following the instructions [here](🔗) to create the visualization of your choice.

You may also run the Python script directly in Power BI by following the instructions [here](🔗).