Resources · Make integration

Microsoft Power BI Make integrationAutomate Microsoft Power BI with Make.

Can Make keep your Power BI data moving without a line of code? The Microsoft Power BI Make integration gives you 24 modules: 1 scheduled trigger, 15 actions and 8 searches. This page shows how to connect your account and build a first scenario step by step.

Try the Microsoft Power BI integration on MakeSee the 24 modules

Verified Trustpilot reviews · AI, automation & growth agency

What you can automate

What can the Microsoft Power BI Make integration do for you?

The Microsoft Power BI Make integration links your Power BI account to Make, a visual tool where you build a scenario (the automation itself) out of modules (one brick each: a trigger, an action or a search). From there you can create datasets, push or delete rows, refresh a dataset, copy reports and read details on apps, dashboards and tiles.

Numbers that land on their own. When a deal closes in your CRM, Add/Delete Rows in a Dataset Table writes it into a push dataset table. The sales report reads that table, and nobody exports a spreadsheet anymore.

A refresh tied to an event. Your finance tool validates an invoice batch? Refresh a Dataset asks Power BI to refresh the dataset you pick, right after the event instead of whenever someone remembers.

A heads-up when a published app changes. Watch Apps spots an updated app, then List App's Reports and List App's Dashboards hand you its content, ready to share with the people who use it.

Where it stops: the Make documentation gives no specific limit for this app, and it warns that its page is AI generated from Microsoft's own docs, so check important details with Microsoft. Anything the other modules miss goes through Make an API Call. Many apps also have an n8n node; read n8n vs Make before you pick a tool, and Make training if scenarios are new to you.

Connect

How do you connect Power BI to Make?

  1. 01

    Register an app in Microsoft Entra ID

    In the Azure portal, open Microsoft Entra ID, then App registrations and New registration. Give it a name, paste the callback URI https://www.integromat.com/oauth/cb/microsoft-power-bi and click Register.

  2. 02

    Copy the three credentials

    From the app overview, copy the Client ID and the Tenant ID. Then go to Certificates and secrets, click New client secret, add a description, choose an expiration period, click Add and copy the secret shown on screen.

  3. 03

    Create the connection in Make

    Add any Microsoft Power BI module to your scenario and click Create a connection. A connection is your account linked to Make once, then reused by every module. Name it if you like, paste the credentials and save.

First scenario

Your first scenario: list the reports of an updated app

GoalWhen an app is updated in Microsoft Power BI, Make lists the reports it contains.

  1. 01

    Create the scenario

    Open the Scenarios page in Make, create a new scenario and click the big +. That empty circle holds the first module, the one that starts the whole chain.

  2. 02

    Add Watch Apps

    Search for Microsoft Power BI, pick Watch Apps and click Create a connection with the Client ID, Tenant ID and client secret you copied earlier.

  3. 03

    Chain List App's Reports

    Click the + on the right of Watch Apps, choose List App's Reports and map the app coming from the trigger. The same connection is reused, no second login.

  4. 04

    Test with Run once

    Click Run once. Make runs the scenario one time, then read the bundles each module received (a bundle is one item passed along, here one report).

  5. 05

    Schedule and switch it on

    Set the schedule on Watch Apps, every 15 minutes by default, and switch the scenario on. Each updated app then sends its list of reports down the chain.

Triggers

What starts a Power BI scenario?

1 module starts a scenario when something happens in Microsoft Power BI. A scheduled trigger is checked by Make on the scenario's schedule; an instant one is called by Microsoft Power BI as soon as it happens.

Microsoft Power BI1Watch Apps

Watch Apps

Scheduled trigger

In Make“Triggers when an app is last updated.”

Watch Apps starts your scenario whenever a Power BI app has been updated, and passes that app to the next module as a bundle. It is the only trigger of this integration, so every automatic start goes through it.

How it fires
scheduled: Make checks the app on the scenario's schedule, every 15 minutes by default (the clock badge on the module). An update shows up at the next check, not the second it happens.
When to use it
you want the reports or dashboards of an app listed after someone republishes it, at the next check.
Watch out
on the Free plan the shortest interval is 15 minutes; paid plans go down to 1 minute.
Modules

What can Make do in Power BI?

Microsoft Power BI gives you 23 modules. For each one: what it does for you, when to reach for it, and what to watch out for.

Microsoft Power BI1

Add/Delete Rows in a Dataset Table

Action

In Make“Adds or deletes rows of a specified push dataset table.”

Fresh rows reach your Power BI tables straight from a scenario, and outdated ones can go: this module adds rows to a push dataset table or deletes rows from it.

When to use it
a deal is won in your CRM or an order is paid in your shop, and the figure belongs in a report without anyone exporting a file.
Watch out
pick a table of a push dataset, the only kind this module targets.
Microsoft Power BI2

Copy a Report

Action

In Make“Copies an existing report.”

A duplicate of an existing report appears in Power BI, so a team can get its own version while the original stays untouched.

When to use it
a new region or a new client needs the same layout as a report you already polished.
Watch out
map the source report from List Reports rather than typing its ID by hand, it avoids copying the wrong one.
Microsoft Power BI3

Create a Dashboard

Action

In Make“Creates a new dashboard.”

A new dashboard is ready in Power BI the moment your scenario runs, with no clicks in the Power BI interface.

When to use it
a project gets created in your project tool and it deserves its own dashboard from day one.
Watch out
put a filter before this module so only the projects that really need a dashboard get one.
Microsoft Power BI4

Create a Dataset

Action

In Make“Creates a new dataset.”

A brand new dataset exists in Power BI as soon as the module runs, giving your other modules a place to write data.

When to use it
you onboard a client and want a dedicated dataset before any row arrives, then fill it with Add/Delete Rows in a Dataset Table.
Watch out
in a scenario that runs often, every run that reaches this module creates one more dataset.
Microsoft Power BI5

Delete a Dataset

Action

In Make“Deletes a dataset.”

Removes a dataset from Power BI for good, which keeps a crowded account tidy when projects end.

When to use it
a client contract closes and its test or temporary dataset has no reason to stay.
Watch out
a delete cannot be undone from Make, so test with Run once on a dummy dataset and put a filter before this module.
Microsoft Power BI6

Delete a Report

Action

In Make“Deletes a report.”

Clears a report out of Power BI without opening it, handy once copies start piling up.

When to use it
a report copied for a one-off campaign is no longer needed once the campaign is archived in your marketing tool.
Watch out
nothing in Make brings it back, so check which report the scenario mapped before you switch it on.
Microsoft Power BI7

Get a Dashboard

Action

In Make“Gets metadata of a specified dashboard.”

You get the details Power BI holds about one dashboard, returned as a single bundle your next modules can read.

When to use it
a message or a ticket mentions a dashboard and you want its details in the same scenario, for example to add them to a task.
Watch out
it returns metadata about the dashboard, not the figures its tiles display.
Microsoft Power BI8

Get a Dashboard Tile

Action

In Make“Gets metadata of a specified dashboard tile.”

One tile, one answer: this module fetches the details of a single tile on a dashboard you choose.

When to use it
you track a specific tile, say the one on churn, and want its details at hand before sending a note to your team.
Watch out
you need both the dashboard and the tile; List Dashboard Tiles gives you the tiles to map.
Microsoft Power BI9

Get a Dataset

Action

In Make“Gets metadata of a specified dataset.”

Reads the details of one dataset, so a scenario can check what it is dealing with before acting on it.

When to use it
before refreshing or deleting a dataset, you want to confirm it is the right one and keep its details in a log.
Watch out
it describes the dataset but returns none of its rows.
Microsoft Power BI10

Get an App

Action

In Make“Gets metadata of a specified app.”

Hands your scenario the details of one Power BI app, the package your colleagues open to reach their reports.

When to use it
Watch Apps just caught an update and you want the full details of that app for a notification or a change log.
Watch out
map the app from the trigger or from List Apps, not a name typed from memory.
Microsoft Power BI11

Get an App's Dashboard

Action

In Make“Gets metadata of a specified app's dashboard.”

Pulls the details of a dashboard that lives inside a given app, which the plain dashboard module does not target.

When to use it
an app was updated and one specific dashboard in it matters to your managers, so you want its details in the message they receive.
Watch out
the app comes first; pick the dashboard within it, often from List App's Dashboards.
Microsoft Power BI12

Get an App's Report

Action

In Make“Gets metadata of a specified app's report.”

Returns the details of one report published inside an app, so a scenario can point people to the version they actually use.

When to use it
after List App's Reports, you keep only the report your sales team follows and read its details before sharing them.
Watch out
use Get a Report instead for a report outside any app.
Microsoft Power BI13

Get a Report

Action

In Make“Gets metadata of a specified report.”

Fetches the details of one report you name, the quickest way to get a report into your scenario when you already know which one it is.

When to use it
you are about to copy or delete a report and want to check its details first.
Watch out
for a report published inside an app, Get an App's Report is the module to pick.
Microsoft Power BI14

Make an API Call

Action

In Make“Performs an arbitrary authorized API call.”

Opens the rest of the Power BI API to your scenario, with the same connection as the other modules, when none of the other modules does what you need.

When to use it
a Power BI operation you read about in Microsoft's docs has no module of its own in Make.
Watch out
you write the request yourself, so keep Microsoft's API reference open while you build it.
Microsoft Power BI15

Refresh a Dataset

Action

In Make“Refreshes a specified dataset.”

Tells Power BI to refresh a dataset right away, so your reports catch up with the source data after an event rather than whenever someone clicks.

When to use it
your accounting tool closes a batch of invoices and finance wants the report updated right after.
Watch out
behind a search, every bundle starts a refresh; filter first so only the right dataset gets one.
Microsoft Power BI16

List Apps

Search

In Make“Retrieves a list of all apps installed.”

Gives you every app installed in your Power BI account, one bundle per app, ready to loop through in the next modules.

When to use it
you audit what is published and want a sheet with one line per app.
Watch out
like any search, it can return zero, one or many bundles, and each bundle runs the modules that follow and counts as operations (one module run on one bundle).
Microsoft Power BI17

List App's Dashboards

Search

In Make“Retrieves a list of dashboards from a specified app.”

Lists the dashboards of one app, so you see at a glance what a published app contains on the dashboard side.

When to use it
after Watch Apps spots an update, you tell the app's users which dashboards they will find in it.
Watch out
an app without dashboards returns no bundle, and the rest of that route simply does not run.
Microsoft Power BI18

List App's Reports

Search

In Make“Retrieves a list of reports from the specified app.”

Brings back the reports of a given app, one bundle each, the natural follow-up when an app changes.

When to use it
a revamped app goes live and your support desk needs the list of reports it now holds.
Watch out
map the app from the trigger or from List Apps; a list with many reports means many bundles, and operations add up.
Microsoft Power BI19

List Dashboards

Search

In Make“Retrieves a list of dashboards.”

Collects the dashboards in your account, a quick inventory you can filter or send elsewhere.

When to use it
you plan a cleanup and want every dashboard listed in a spreadsheet to decide what stays.
Watch out
dashboards that live inside an app are reached with List App's Dashboards; add a filter after this module so you only keep the ones you care about.
Microsoft Power BI20

List Dashboard Tiles

Search

In Make“Retrieves a list of dashboard tiles.”

Breaks a dashboard down into its tiles, one bundle per tile, so you can work on each tile separately.

When to use it
you want to find the tile on revenue in a crowded dashboard before reading it with Get a Dashboard Tile.
Watch out
choose the dashboard first; the module only lists tiles of the dashboard you mapped.
Microsoft Power BI21

List Datasets

Search

In Make“Retrieves a list of datasets.”

Shows the datasets available to your connection, the starting point for any scenario that picks a dataset on its own.

When to use it
you want to refresh every dataset whose name matches a client, found here and then passed to Refresh a Dataset.
Watch out
put a filter between the search and the action, or every dataset in the list gets refreshed.
Microsoft Power BI22

List Dataset Users

Search

In Make“Retrieve a list of a specified dataset's users. This can be used by admin.”

Tells you who has access to a dataset, one bundle per user, which makes access reviews far less tedious.

When to use it
someone leaves the company and your IT lead wants to see which datasets they could still open.
Watch out
Make's documentation presents this module as one for admins, so connect it with an account that has admin rights.
Microsoft Power BI23

List Reports

Search

In Make“Retrieves a list of reports.”

Returns the reports of your account in one pass, the base for inventories, copies and cleanups.

When to use it
you feed a catalog of reports in your wiki, or you look for the report to duplicate with Copy a Report.
Watch out
reports published inside an app come from List App's Reports instead.
Need help

Need help automating Microsoft Power BI with Make?

A person reads every message.

FAQ

Microsoft Power BI and Make: common questions

01Is the Microsoft Power BI Make integration free?
Yes, on the Make side. Microsoft Power BI is a standard app, so it works from the Free plan. That plan allows 2 active scenarios, a 15 minute minimum between two scheduled runs, 5 minutes of execution per run, files up to 5 MB and 512 MB of data transfer. Paid plans (Core, Pro, Teams and Enterprise) lower the interval to 1 minute and remove the cap on active scenarios. Your Power BI account is a separate matter: Microsoft sets its own subscription, and the Make documentation sends you to the Power BI pricing page for it.
02What do you need to connect Microsoft Power BI to Make?
You need an active Power BI account and an app registered in Microsoft Entra ID, in the Azure portal, with the right permissions. During registration you enter the callback URI given by the Make documentation. Then you copy three values: the Client ID and the Tenant ID from the app overview, and a client secret created under Certificates and secrets. In Make, you add a Power BI module, click Create a connection, name it if you want and paste those credentials. Every Power BI module in your scenarios then reuses that connection.
03Does the Microsoft Power BI trigger in Make work in real time?
No. Watch Apps, the only trigger of this integration, is a scheduled trigger: Make checks for updated apps on the scenario's schedule, every 15 minutes by default, and the module shows a clock badge. There is no instant trigger, the kind an app would call through a webhook the moment something happens. On the Free plan you cannot check more often than every 15 minutes; paid plans go down to 1 minute. For the action modules, the start usually comes from another app's trigger, and the Power BI module runs right after it.
04What if the Power BI module you need is missing in Make?
Use Make an API Call. It is part of this integration and lets your scenario call any endpoint of the Power BI API with the same connection as the other modules, so an operation without its own module is still within reach. You write the request yourself, which means reading Microsoft's API reference. Keep in mind that the Make documentation for this app gives no specific limit and states that it is AI generated from Microsoft's documentation, so it is worth checking an important detail with Microsoft before relying on it.
05Make or n8n for Microsoft Power BI?
It depends on the tool your team already runs and on what the app offers there. On Make, Power BI comes with 24 modules: 1 scheduled trigger, 15 actions and 8 searches, including Make an API Call for the rest of the API, and it is available from the Free plan. Many apps also have an n8n node, so check what n8n offers for Power BI on your side before choosing. Compare the modules you actually need, the connection steps and how your team likes to build, rather than a general ranking.
Same platform

Other docs you might need on this stack.

Browse all integrations