--- title: "Plug Power BI to your Data Platform" description: "Are you or your teammates already proficient with Microsoft Power BI? If you want to use it as your analytics solution on top your Data Platform" url: https://docs.ovhcloud.com/it/guides/public-cloud/data-platform/connectors-consumers-power-bi lang: it lastUpdated: 2026-09-14 --- > For AI agents: the complete documentation index is available at https://docs.ovhcloud.com/it/llms.txt, the full documentation bundle is available at https://docs.ovhcloud.com/it/llms-full.txt. # Plug Power BI to your Data Platform ## Objective 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](/images/public-cloud/data-platform/product/connectors/consumers/power-bi/picts/powerbi-001.png) 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](https://docs.ovhcloud.com/it/guides/public-cloud/data-platform/landing-page-connectors-consumers.md) _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](/images/public-cloud/data-platform/product/connectors/consumers/power-bi/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](https://docs.ovhcloud.com/it/guides/public-cloud/data-platform/tutorials-generate-api-keys.md). 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 :::warning 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](/images/public-cloud/data-platform/product/connectors/consumers/power-bi/picts/powerbi-install1.png) Open the **Options and settings** section, then select **Options**. ![pbi](/images/public-cloud/data-platform/product/connectors/consumers/power-bi/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](/images/public-cloud/data-platform/product/connectors/consumers/power-bi/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: ```yaml 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. :::warning 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](/images/public-cloud/data-platform/product/connectors/consumers/power-bi/picts/powerbi-get-data.png) Search for _Trino_, and select the connector. ![pbi](/images/public-cloud/data-platform/product/connectors/consumers/power-bi/picts/powerbi-forepaas-connector.png) You now have to enter the [URL of the Data Platform Project](https://docs.ovhcloud.com/it/guides/public-cloud/data-platform/manage-projects-config-variables.md) 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](/images/public-cloud/data-platform/product/connectors/consumers/power-bi/picts/powerbi-dp-url-consumer.png) ![pbi](/images/public-cloud/data-platform/product/connectors/consumers/power-bi/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](/images/public-cloud/data-platform/product/connectors/consumers/power-bi/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](/images/public-cloud/data-platform/product/connectors/consumers/power-bi/picts/powerbi-import.png) You can now create your first visualizations on your data from your Data Platform project using Power BI Desktop. :::info 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](/images/public-cloud/data-platform/product/connectors/consumers/power-bi/picts/powerbi-dashboard.png) ## Go further If you need training or technical assistance to implement our solutions, contact your sales representative or click on [this link](https://www.ovhcloud.com/it/professional-services/) to get a quote and ask our Professional Services experts for a custom analysis of your project. Ask questions, give your feedback and interact directly with the team building the Data Platform on the dedicated [Discord channel](https://discord.gg/ovhcloud). If you need support with your OVHcloud services, create a request in our [Help Centre](https://help.ovhcloud.com/csm?id=csm_get_help). Join our [community of users](https://community.ovhcloud.com/).