Business Intelligence
Microsoft Power BI
20 min
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 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 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, https //www microsoft com/en us/power platform/products/power bi for subscription, refer to the https //www microsoft com/en us/power platform/products/power bi connect microsoft power bi and {{product name}} to get started, you must first create a connection between microsoft power bi and {{product name}} , allowing the two services to communicate obtain your oauth2 clientcredentials credentials in your microsoft power bi account create the connection in make obtain your oauth2 clientcredentials credentials in your microsoft power bi account before you create the connection in {{product name}} , you should first obtain your oauth2 clientcredentials credentials in your microsoft power bi account to obtain your oauth2 clientcredentials credentials navigate to the microsoft entra id section within the azure portal click app registrations in the sidebar click new registration enter your application name enter the callback uri https //www integromat com/oauth/cb/microsoft power bi click register copy the client id displayed in the application overview copy the tenant id displayed in the application overview click certificates and secrets in the left menu click new client secret enter a description and select an expiration period click add copy the client secret displayed on screen you will use this value while creating a connection in {{product name}} because the ui might have changed, the steps you see on your screen might be different, https //learn microsoft com/en us/power bi/developer/embedded/embed service principal create the connection in {{product name}} https //www make com/en/register , add the microsoft power bi module to your {{scenario singular lowercase}} , and click create a connection if you add a module with an instant tag, click create a webhook , then create a connection optional in the connection name field, enter a name for the connection 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 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 {{scenario plural lowercase}} add/delete rows in a dataset table adds new rows to or removes existing rows from a specified table within a push dataset copy a report creates a duplicate of a selected report create a dashboard creates a new dashboard for organizing and displaying your data visually create a dataset creates a new dataset for storing and organizing your data delete a dataset permanently removes a specified dataset from your account delete a report permanently removes a specified report from your account get a dashboard retrieves detailed information and properties for a selected dashboard get a dashboard tile retrieves detailed metadata information for a specific dashboard tile you select get a dataset retrieves detailed metadata information for a selected dataset get a report retrieves detailed metadata information for a selected report get an app retrieves detailed information and properties about a selected app get an app's dashboard retrieves detailed information about the dashboard of a selected app get an app's report retrieves detailed metadata information for a specific report within the selected app list app's dashboards fetches all dashboards available within a selected application list app's reports fetches a list of available reports from the selected application list apps retrieves a complete list of all applications currently installed in your account list dashboard tiles fetches a list of all tiles displayed on a specified dashboard list dashboards fetches and displays a list of all available dashboards from your account list dataset users retrieve a list of all users associated with a specified dataset, accessible by administrators list datasets fetches and displays a list of available datasets from your account list reports fetches and displays a list of available reports from your account make an api call executes a custom api request to the connected service using your authorized credentials refresh a dataset updates the data in a selected dataset to ensure it contains the most recent information watch apps triggers when the most recent update is made to an app templates you can look for more templates in https //www make com/en/templates , where you'll find thousands of pre created {{scenario plural lowercase}} microsoft power bi resources you can have access to more resources related to this app on the following links https //community make com/search?q=microsoft%20power%20bi https //www microsoft com/en us/power platform/products/power bi https //docs microsoft com/en us/rest/api/power bi/ https //www make com/en/integrations/microsoft power bi