# Plug Power BI to your Data Platform

Are you or your teammates already proficient with [Microsoft Power BI](https://powerbi.microsoft.com/en-us/getting-started-with-power-bi/)? If you want to use it as your analytics solution on top your Data Platform, this guide is for you.

![pbi](picts/powerbi-001.jpeg)

The configuration is done in two parts. First you need to [configure the consumer on Data Platform](#how-to-configure-power-bi-with-your-data-platform) and then [configure the connector on Power BI Desktop](#configuration-on-power-bi).

---
## How to configure Power BI with your Data Platform

If you haven't done so already, [add a new](/en/product/connectors/consumers/index?id=create-a-consumer) *Power BI* consumer in the Connectors. Else, just edit it.

Since the Trino connector for Power BI is an open sourced project and not yet certified by Microsoft, you have to **download the extension**, either manually from [this link](https://raw.githubusercontent.com/CreativeDataEU/PowerBITrinoConnector/refs/heads/master/Trino/bin/AnyCPU/Debug/Trino.mez) or from the interface shown below.

![pbi](picts/powerbi-download.png)

Power BI users will have to be registered in a Project's Identity Access Manager (IAM) in order to access its data. They will only access the data associated to their [API Secret Key](en/getting-further/generate-api-key/api-secret-key).

You can **easily grant full access to a new Power BI user** by assigning them the *Analytics Consumer* role. This is a default role that can be assigned to a group, user, or service account and provides the appropriate permissions to view data from an external consumer.

Alternatively, if you prefer to fine-tune permissions, you can go to your project's Identity Access Manager and grant the user the following specific permissions:

*   *Data Manager | Source | Read* and *Data Manager | Table | Read*: to import a table's data inside Power BI
*   *Advanced Data Access Control | Read*: to access the data inside the project

!> Any user who has the role of **Admin** will also have access to the Project's data

---
## Configuration on Power BI

Once you have [downloaded](https://raw.githubusercontent.com/CreativeDataEU/PowerBITrinoConnector/refs/heads/master/Trino/bin/AnyCPU/Debug/Trino.mez) the connector *.MEZ* file, follow this procedure to use it on **Power BI Desktop**. 


### Allow your Power BI Desktop to use a custom connector

Open *Power BI Desktop*. Click on **File** in the header.

![pbi](picts/powerbi-install1.png)

Open the **Options and settings** section, then select **Options**.

![pbi](picts/powerbi-install2.png)

Find the **Global > Security** section, then activate the following option: *(Not Recommended) Allow any extension to load without validation or warning*.

![pbi](picts/powerbi-install3.png)

This will allow you to get data from a source not yet certified by Microsoft, in this case the Trino Connector.

Now, **close Power BI Desktop** for the changes to be applied.

### Install the connector

Create this folder in your user directory:

```
C:\Users\[Your_Windows_User_Name]\Documents\Microsoft Power BI Desktop\Custom Connectors
```

If the *Microsoft Power BI Desktop\Custom Connectors* folders already exists, then you don't have to create it.

!> Make sure that the folders have exactly the same names as above, or you won't be able to find the Trino connector inside Power BI Desktop.

Copy the connector *.MEZ* file that you have previously downloaded into this new directory. 

You can now restart Power BI Desktop.

### Import your first data from Data Platform

Click on **Get Data**.

![pbi](picts/powerbi-get-data.png)

Search for *Trino*, and select the connector.

![pbi](picts/powerbi-forepaas-connector.png)

You now have to enter the [URL of the Data Platform Project](en/product/project/config-ids) you want to connect to. You can easily find this URL on the page of the consumer on the Data Platform project. The port is 443.

![pbi](picts/powerbi-dp-url-consumer.png)

![pbi](picts/powerbi-dp-url.png)

If you are not yet authenticated to this Project, you will be asked to authenticate at this step. 

Choose the Basic mode and use **API key** for User name and **Secret key** for Password as configured to your Service-Account/User in IAM.

![pbi](picts/powerbi-auth1.png)

When you are successfully authenticated, press **connect** to continue.

Then you will see your datasets, schemas and tables in preview mode.

![pbi](picts/powerbi-import.png)

You can now create your first visualizations on your data from your Data Platform project using Power BI Desktop. 

> If the data is updated on Data Platform, graphs can be manually refreshed with the latest data by pressing the refresh button in the Power BI header. 

![pbi](picts/powerbi-dashboard.png)


---
## Struggling to set it up by yourself❓

> At any step, you can create a ticket to raise an incident or if you need support at the [OVHcloud Help Centre](https://help.ovhcloud.com/csm/fr-home?id=csm_index). Additionally, you can ask for support by reaching out to us on the Data Platform Channel within the [Discord Server](https://discord.com/channels/850031577277792286/1163465539981672559). There is a step-by-step guide in the [support](/en/support/index.md) section.