All integrations
Microsoft Power BI logo

Microsoft Power BI

AnalyticsMicrosoft

Manage reports, semantic models (datasets), push data, and dashboards in your Power BI My workspace. List, get, clone, and delete reports; list, get, delete, and refresh semantic models, read and update their refresh schedule, and run DAX queries against them; create a push dataset, add and clear rows in its tables; and list, create, and delete dashboards. Connects with delegated OAuth 2.0 through Microsoft Entra ID.

20 actions

Actions

Steps your workflow can run in Microsoft Power BI.

List reportsList the reports in your My workspace, including reports shared with you and reports from apps (their names start with [App]).
Get a reportGet one report: its name, type, link and the semantic model it reads from.
Clone a reportCopy a report within My workspace under a new name, optionally pointing the copy at a different semantic model. You need edit rights on the report, and Build permission on the other model if you choose one.
Delete a reportPermanently delete a report from My workspace. Its semantic model is not deleted.
List report pagesList a report's pages in the order they appear.
List semantic modelsList the semantic models (datasets) in your My workspace, imported models and push datasets alike.
Get a semantic modelGet one semantic model (dataset): who configured it, when it was created, and whether it can be refreshed or take rows.
Delete a semantic modelPermanently delete a semantic model (dataset) from My workspace. Reports built on it may stop working or be removed with it.
Refresh a semantic modelStart a refresh of an imported semantic model. Power BI runs it in the background; use 'List refresh history' to see how it went. On shared capacity (every Free and Pro workspace) a model can be refreshed at most eight times a day, counting scheduled refreshes. Push datasets cannot be refreshed.
List refresh historyList a semantic model's recent refreshes, newest first, with their status and any error. Power BI keeps between 20 and 60 entries, and none for models refreshed from OneDrive.
Get refresh scheduleGet an imported semantic model's scheduled refresh: whether it is on, and on which days and at which times it runs.
Update refresh scheduleChange an imported semantic model's scheduled refresh. Only the fields you fill in change. Turning the schedule off changes nothing else, as Power BI requires. You must own the model, and shared capacity allows up to eight times a day.
Run a DAX queryRun one DAX query against a semantic model and get the rows back. Column names come back qualified, such as 'Sales[Amount]'. Limited to one table of 100,000 rows or 1,000,000 values. Your Power BI admin must have the tenant setting 'Dataset Execute Queries REST API' on.
Create a push datasetCreate a semantic model in My workspace that you fill by adding rows from a workflow, with one table. Build reports on it in Power BI. Up to 75 columns.
List push dataset tablesList a push dataset's tables and their columns. Works on push datasets only; query an imported model with DAX instead.
Add rowsAdd rows to a push dataset's table: up to 10,000 per step, each an object of column name to value.
Delete all rows in a tableDelete every row in a push dataset's table. The table and its columns stay. This cannot be undone and cannot delete only some rows.
List dashboardsList the dashboards in your My workspace.
Create a dashboardCreate an empty dashboard in My workspace. Pin tiles to it from reports in Power BI.
Delete a dashboardPermanently delete a dashboard from My workspace. The reports its tiles came from are not affected.

Connect in a few clicks

Authenticate once and every action and trigger for the app is ready to drop into a workflow. No glue code, no maintenance.

Automate across your stack

Chain apps together with triggers, actions, and logic that move data between your tools automatically, so work happens without you.

Secure by default

Credentials are encrypted and scoped per workspace. Connect the tools your team already trusts with confidence.

Automate Microsoft Power BI with Lodol.

Connect Microsoft Power BI and build your first workflow in minutes. No credit card required.

Free plan available · No credit card required