--- title: How to work with Power BI description: Introduction ISOPlanner data can be surfaced in Microsoft Power BI to create interactive reports. Most data entities and relations between them can be used. --- [Skip to content](https://docs.isoplanner.app/how-to-work-with-powerbi#main-content) [![ISOPlanner 2000x500 transparent no shadow](https://docs.isoplanner.app/hs-fs/hubfs/ISOPlanner%202000x500%20transparent%20no%20shadow.png?width=200&height=50&name=ISOPlanner%202000x500%20transparent%20no%20shadow.png)](https://isoplanner.app) Open main navigation Close main navigation How can we help you? - There are no suggestions because the search field is empty. 1. [ISOPlanner](https://docs.isoplanner.app/) 2. [Power BI](https://docs.isoplanner.app/power-bi) # How to work with Power BI Introduction ISOPlanner data can be surfaced in Microsoft Power BI to create interactive reports. Most data entities and relations between them can be used. For example, you can create a new report and add Risks, Controls and Tasks and the relations between them to quickly create a report which shows overdue monitoring tasks related to controls that mitigate risks with a high risk classification. These reports can be shown on a dashboard in ISOPlanner. You control who is authorized to view and share and all data remains in your Microsoft Power BI environment. Premium users can create reports that contain data of multiple organizational units. Requirements 1. ISOPlanner Business or Premium subscription. 2. ISOPlanner Management User license. 3. Power BI license. [Click here for more information/pricing](https://powerbi.microsoft.com/pricing/)   Installation We are currently working with Microsoft to certify our Power BI connector. Until this is process finished, the connector must be installed on the computer where you create your reports with Microsoft Power BI Desktop. In addition, to refresh the data of the reports periodically and automatically, the Microsoft On-premise Gateway must be installed and configured. These steps can be skipped when Microsoft has enough community feedback that this connector should be certified. [Click here to ask Microsoft for certification on this Microsoft forum. Thank you!](https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=a4da98b3-f6fb-ee11-a73c-6045bdbe85bd)   Get started - Please check the requirement section above - In ISOPlanner, in the menu Administration / Settings / Tab: Integration, [enable the Power BI integration](https://portal.isoplanner.app/admin/settings/integration) and give the permissions. ![](https://docs.isoplanner.app/hs-fs/hubfs/Knowledge%20Base%20Import/Power-BI-permissions-300x113.png?width=300&name=Power-BI-permissions-300x113.png) 1. Install [Microsoft Power BI Desktop](https://www.microsoft.com/store/productId/9NTXR16HNW1T?ocid=pdpshare) from the Microsoft Store or contact your IT-department. 2. Download the [ISOPlanner BI connector here](https://docs.isoplanner.app/hubfs/ISOPlanner%20Power%20BI%20Connector%201.3.1.zip). 3. This file (.mez) must be placed on your local computer where you want to create reports using Microsoft Power BI Desktop. 4. After download, copy the file to your local \[Documents\]\\Power BI Desktop\\Custom Connectors. Create the folder if they do not exist. It can be a local folder on your C: drive or OneDrive. Please refer to the [Microsoft documentation here](https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-connector-extensibility). E.g *C:\\Users\\Chris\\OneDrive\\Documents\\Power BI Desktop\\Custom Connectors\\ISOPlannerBI.mez*. Please note that your \[Documents\] folder is localized to your language. 5. Start Microsoft Power BI Desktop 6. Change the setting to allow loading custom connectors. Please refer to the [Microsoft documentation here.](https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-connector-extensibility) 7. Create a **New report**, click ‘**Get data**‘ in the toolbar, click **More** and search for ‘**iso**‘. The ISOPlanner BI connector should show. If not, please check step 5. ![](https://docs.isoplanner.app/hs-fs/hubfs/Knowledge%20Base%20Import/powerbi1.png?width=670&name=powerbi1.png)   Your first report 1. Start Microsoft Power BI Deskop 2. Click **New report**, click ‘**Get data**‘ in the toolbar, click **More** and search for ‘**iso**‘. 3. Select the **ISOPlanner BI** connector and click **Connect**. 4. Click **Sign in** and log in with your Microsoft work account (same as ISOPlanner). 5. Grant the permissions to ISOPlanner SVC (our back-end service) to connect to ISOPlanner as you (user impersonation). These permissions allow only to ‘connect’ and do not request additional authorization. The actual authorization is enforced by your management license in ISOPlanner. (Users without this authorization will not be able to connect.) 6. Click **Connect**. ![](https://docs.isoplanner.app/hs-fs/hubfs/Knowledge%20Base%20Import/powerbi2.png?width=670&name=powerbi2.png) 1. The Navigator appears. Here you can select the data. Open the **Tasks and Events** section. Select **Task** and click **Load**. ![](https://docs.isoplanner.app/hs-fs/hubfs/Knowledge%20Base%20Import/powerbi4.png?width=670&name=powerbi4.png) 1. Add a ‘Stacked column chart’ to the report. ![](https://docs.isoplanner.app/hs-fs/hubfs/Knowledge%20Base%20Import/powerbi5-1.png?width=239&name=powerbi5-1.png) 1. In the **Data** pane, drag the field **assigneeName** to the **X-axis** and **taskId** to the **Y-axis** 2. Drag the field **status** to the **legend** ![](https://docs.isoplanner.app/hs-fs/hubfs/Knowledge%20Base%20Import/powerbi6.png?width=609&name=powerbi6.png) 1. Drag the field **deadlinePassed** to the **visual filters** and select **True** as the only value. 2. In the filter for assigneeName, select all fields except **(Blank)**. 3. Now you have created a report that shows all assigned tasks over deadline, grouped by assignee and stacked by status. ![](https://docs.isoplanner.app/hs-fs/hubfs/Knowledge%20Base%20Import/powerbi7.png?width=670&name=powerbi7.png) Resources 1. [Publishing a report to Power BI Service and ISOPlanner dashboards](https://docs.isoplanner.app/publishing-a-report-to-power-bi-service-and-isoplanner-dashboards/) 2. [Automatically refreshing the data of a report](https://docs.isoplanner.app/automatically-refresh-report-data/) 3. [General data model guidelines](https://docs.isoplanner.app/general-data-model-guidelines/) 4. [Data model tables and fields](https://docs.isoplanner.app/data-model-tables-and-fields/) - [Getting Started](https://docs.isoplanner.app/getting-started) - [Main Concepts](https://docs.isoplanner.app/main-concepts) - [Common Elements](https://docs.isoplanner.app/common-elements) - [Administration Menu](https://docs.isoplanner.app/administration-menu) - [FAQ](https://docs.isoplanner.app/faq) - [Videos](https://docs.isoplanner.app/videos) - [Apps & Add-ins](https://docs.isoplanner.app/apps-add-ins) - [Automated Control Monitoring](https://docs.isoplanner.app/automated-control-monitoring) - [Developer](https://docs.isoplanner.app/developer) - [Power Automate](https://docs.isoplanner.app/power-automate) - [Power BI](https://docs.isoplanner.app/power-bi) - [Release Notes](https://docs.isoplanner.app/release-notes) - [Transition Guides](https://docs.isoplanner.app/transition-guides) [![ISOPlanner 2000x500 transparent no shadow](https://docs.isoplanner.app/hs-fs/hubfs/ISOPlanner%202000x500%20transparent%20no%20shadow.png?width=200&height=50&name=ISOPlanner%202000x500%20transparent%20no%20shadow.png "ISOPlanner 2000x500 transparent no shadow")](https://docs.isoplanner.app/) [mailto:support@isoplanner.app](mailto:support@isoplanner.app) Copyright © 2026, ISOPlanner