--- title: Microsoft Power BI slug: microsoft-power-bi description: How to integrate Microsoft Power BI with Make.com image: https://make-cxp-documentation.ams3.digitaloceanspaces.com/apps-center-icons/PREVIEW_microsoft-power-bi.png createdAt: 2025-02-03T13:28:18.713Z --- | :inlineImage[]{src="https://make-cxp-documentation.ams3.digitaloceanspaces.com/apps-center-icons/microsoft-power-bi.png" alt="Microsoft Power BI logo" caption size="50" width="512" height="512"} | Microsoft Power BI is a business analytics tool that enables users to visualize data, share insights, and make data-driven decisions. Integrating Power BI with Make.com allows users to automate report generation, dashboard updates, and data synchronization across business systems. | | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | :::hint{type="warning"} This is AI-generated content based on official Microsoft Power BI documentation. The content may contain mistakes. Please verify important information. If you have questions on vendor documentation, contact [Microsoft Power BI](https://www.microsoft.com/en-us/power-platform/products/power-bi) directly. ::: # Requirements To use the Microsoft Power BI app in Make, you must have an active Power BI account and a registered Azure Active Directory application with appropriate permissions, [create your account on Microsoft Power BI](https://www.microsoft.com/en-us/power-platform/products/power-bi). For subscription, refer to the [Microsoft Power BI pricing page](https://www.microsoft.com/en-us/power-platform/products/power-bi). # Connect Microsoft Power BI and Make To get started, you must first create a connection between Microsoft Power BI and Make, allowing the two services to communicate. ::::WorkflowBlock :::WorkflowBlockItem **Obtain your OAuth2 ClientCredentials credentials in your Microsoft Power BI account** ::: :::WorkflowBlockItem **Create the connection in Make.** ::: :::: ## Obtain your OAuth2 ClientCredentials credentials in your Microsoft Power BI account Before you create the connection in Make, you should first obtain your **OAuth2 ClientCredentials credentials** in your Microsoft Power BI account. To obtain your **OAuth2 ClientCredentials credentials **: ::::WorkflowBlock :::WorkflowBlockItem Navigate to the** Microsoft Entra ID** section within the Azure portal. ::: :::WorkflowBlockItem Click** App registrations** in the sidebar. ::: :::WorkflowBlockItem Click** New registration**. ::: :::WorkflowBlockItem Enter your application name. ::: :::WorkflowBlockItem Enter the callback URI: `https://www.integromat.com/oauth/cb/microsoft-power-bi`. ::: :::WorkflowBlockItem Click** Register**. ::: :::WorkflowBlockItem Copy the** Client ID** displayed in the application overview. ::: :::WorkflowBlockItem Copy the** Tenant ID** displayed in the application overview. ::: :::WorkflowBlockItem Click** Certificates and secrets** in the left menu. ::: :::WorkflowBlockItem Click** New client secret**. ::: :::WorkflowBlockItem Enter a description and select an expiration period. ::: :::WorkflowBlockItem Click Add. ::: :::WorkflowBlockItem Copy the** Client secret** displayed on screen. ::: :::: You will use this value while creating a connection in Make. Because the UI might have changed, the steps you see on your screen might be different, [check the vendor documentation for updates.](https://learn.microsoft.com/en-us/power-bi/developer/embedded/embed-service-principal) ## Create the connection in Make :::::WorkflowBlock ::::WorkflowBlockItem [[Log in in your Make](https://www.make.com/en/register) account](https://www.make.com/en/register), add the Microsoft Power BI module to your scenario, and click **Create a connection. ** :::hint{type="info"} If you add a module with an instant tag, click **Create a webhook**, then **Create a connection.** ::: :::: :::WorkflowBlockItem *Optional: *In the **Connection name** field, enter a name for the connection. ::: :::WorkflowBlockItem Enter the **authentication credentials** you copied from your Microsoft Power BI account or follow the on-screen instructions to create the connection. ::: ::::: For detailed information on connecting an application, see **[Connect an application](docId\:SO88FM6pkT0G-adKDDfzZ)** page. # Microsoft Power BI modules After connecting to the Microsoft Power BI app, you can choose from a list of available modules to build your scenarios. :::ExpandableHeading ### Add/Delete Rows in a Dataset Table Adds new rows to or removes existing rows from a specified table within a push dataset. ::: :::ExpandableHeading ### Copy a Report Creates a duplicate of a selected report. ::: :::ExpandableHeading ### Create a Dashboard Creates a new dashboard for organizing and displaying your data visually. ::: :::ExpandableHeading ### Create a Dataset Creates a new dataset for storing and organizing your data. ::: :::ExpandableHeading ### Delete a Dataset Permanently removes a specified dataset from your account. ::: :::ExpandableHeading ### Delete a Report Permanently removes a specified report from your account. ::: :::ExpandableHeading ### Get a Dashboard Retrieves detailed information and properties for a selected dashboard. ::: :::ExpandableHeading ### Get a Dashboard Tile Retrieves detailed metadata information for a specific dashboard tile you select. ::: :::ExpandableHeading ### Get a Dataset Retrieves detailed metadata information for a selected dataset. ::: :::ExpandableHeading ### Get a Report Retrieves detailed metadata information for a selected report. ::: :::ExpandableHeading ### Get an App Retrieves detailed information and properties about a selected app. ::: :::ExpandableHeading ### Get an App's Dashboard Retrieves detailed information about the dashboard of a selected app. ::: :::ExpandableHeading ### Get an App's Report Retrieves detailed metadata information for a specific report within the selected app. ::: :::ExpandableHeading ### List App's Dashboards Fetches all dashboards available within a selected application. ::: :::ExpandableHeading ### List App's Reports Fetches a list of available reports from the selected application. ::: :::ExpandableHeading ### List Apps Retrieves a complete list of all applications currently installed in your account. ::: :::ExpandableHeading ### List Dashboard Tiles Fetches a list of all tiles displayed on a specified dashboard. ::: :::ExpandableHeading ### List Dashboards Fetches and displays a list of all available dashboards from your account. ::: :::ExpandableHeading ### List Dataset Users Retrieve a list of all users associated with a specified dataset, accessible by administrators. ::: :::ExpandableHeading ### List Datasets Fetches and displays a list of available datasets from your account. ::: :::ExpandableHeading ### List Reports Fetches and displays a list of available reports from your account. ::: :::ExpandableHeading ### Make an API Call Executes a custom API request to the connected service using your authorized credentials. ::: :::ExpandableHeading ### Refresh a Dataset Updates the data in a selected dataset to ensure it contains the most recent information. ::: :::ExpandableHeading ### Watch Apps Triggers when the most recent update is made to an app. ::: # Templates You can look for more templates in [Make's template gallery](https://www.make.com/en/templates), where you'll find thousands of pre-created scenarios. # Microsoft Power BI resources You can have access to more resources related to this app on the following links - [Microsoft Power BI topics on Make community](https://community.make.com/search?q=Microsoft%20Power%20BI) - [Microsoft Power BI website](https://www.microsoft.com/en-us/power-platform/products/power-bi) - [Microsoft Power BI API documentation](https://docs.microsoft.com/en-us/rest/api/power-bi/) - [Microsoft Power BI page on make](https://www.make.com/en/integrations/microsoft-power-bi) *** :::CtaButton{label="Get started for free" externalHref="https://www.make.com/en/register" openInNewTab="true"} :::