Skip to content

Start building

MyDeepAgentsMyDeepAgents

Integration · Analytics and data

AI agents for Power BI

List Power BI workspaces and semantic models, refresh a model, push rows into a push dataset and run DAX queries, as the signed-in person.

Start buildingTalk to us
Actions
5
Read
3
Write
2

Actions

What your agents can do in Power BI

List Power BI workspaces and semantic models, refresh a model, push rows into a push dataset and run DAX queries, as the signed-in person. Needs a work or school account with Power BI.

Read 3

Look things up. Nothing changes.

  • List workspaces

    Lists the Power BI workspaces the person can open, optionally only those whose name contains some words.

  • List semantic models

    Lists the semantic models (datasets) in a workspace, by the workspace's ID.

  • Run a DAX query

    Runs one DAX query against a semantic model, by the workspace's and model's IDs, and returns its single result table as results[0].tables[0].rows, each row an object keyed by column.

Write 2

Create, change or send.

  • Refresh a semantic model

    Starts a data refresh of a semantic model in a workspace, by their IDs, and optionally emails the model's owner when it fails or finishes.

  • Add rows to a push dataset

    Appends rows to a table of a push dataset (one whose addRowsAPIEnabled is true), by the workspace's and dataset's IDs and the table's name.

A person can approve first

Any write action can be set to wait for a person's approval before it runs, so an agent asks before it changes anything.

Connection

How it connects

Connect it once in the console, then give it to the agents and workflows that need it.

Sign in (OAuth)

Sign in with Microsoft and approve access (OAuth).

Kept safe

  • Credentials are stored encrypted with your organization's own keys.
  • They are opened only by the process that makes the call, at the moment it runs, and never go into a prompt or the browser.
  • Calls go only to the tool's own servers.

How we protect your data

Ideas

Ideas to start with

Starting points made only from the actions above. Mix them with any other tool your agents can use.

  • 01

    Ask about your Power BI data

    Ask a question in plain words. The agent can list workspaces, list semantic models or run a DAX query in Power BI, then answers with what it found.

  • 02

    Let an agent update Power BI

    Have the agent refresh a semantic model or add rows to a push dataset in Power BI as part of a larger task. Turn on approval and a person signs off on each change first.

  • 03

    Share what it finds in Slack

    Give one agent Power BI and Slack: it can list workspaces in Power BI and post a summary to a Slack channel in the same run.

FAQ

Power BI and MyDeepAgents

Can MyDeepAgents connect to Power BI?

Yes. The Power BI connector has 5 actions: 3 read and 2 make changes. Your agents can call them as tools, and your workflows can run them as steps.

How do I connect Power BI?

Sign in with Microsoft and approve access (OAuth). Credentials are stored encrypted with your organization's own keys and are opened only at the moment of a call.

Can an agent change data in Power BI without asking?

Only if you let it. Each of the 2 actions that change data can be set to wait for a person's approval before it runs.

Can I use Power BI in workflows as well as agents?

Yes. Every Power BI action also works as a step in a workflow, and the same connection serves your agents and your workflows.

Early access

Put Power BI to work

Connect it in a few minutes, give an agent the actions it needs, and decide which changes wait for a person.

Start buildingBrowse all integrations