MULTI-APP TOOLKIT
Build with Datadog + Microsoft Power BI
- Multi-app
- One MCP session
- 28 actions
- 4 triggers
- Managed auth
MCP
One MCP session, both toolsets
One session gives your product or agent every Datadog and Microsoft Power BI tool at once — connect once, list tools, and call them like any single-app session.
// accessToken: mint a short-lived token with the Connect SDK — see the MCP guide
const transport = new StreamableHTTPClientTransport(
new URL("https://remote.mcp.pipedream.net/v3"),
{
requestInit: {
headers: {
Authorization: `Bearer ${accessToken}`,
"x-pd-project-id": "{project_id}",
"x-pd-environment": "production",
"x-pd-external-user-id": "{external_user_id}", // any stable ID for this user in your system
"x-pd-app-slug": "datadog,microsoft_power_bi",
},
},
},
)
const mcp = new Client({ name: "my-agent", version: "1.0.0" })
await mcp.connect(transport)
const { tools } = await mcp.listTools()
// One list, both toolsets: Datadog and Microsoft Power BI tools arrive
// together, each keyed by its own app's slug.
// e.g. run Get Account Info:
const result = await mcp.callTool({
name: "datadog-get-account-info",
arguments: {},
})import { PipedreamClient } from "@pipedream/sdk"
const pd = new PipedreamClient({
projectId: process.env.PIPEDREAM_PROJECT_ID!,
clientId: process.env.PIPEDREAM_CLIENT_ID!,
clientSecret: process.env.PIPEDREAM_CLIENT_SECRET!,
projectEnvironment: "production",
})
const externalUserId = "{external_user_id}" // any stable ID for this user in your system
const [datadogTools, microsoftPowerBiTools] =
await Promise.all([
pd.components.list({ app: "datadog" }),
pd.components.list({ app: "microsoft_power_bi" }),
])
// One external user owns both connected accounts, so either app's tools
// run on their behalf with the same externalUserId.curl "https://api.pipedream.com/v1/connect/{project_id}/components?app=datadog" \
-H "X-PD-Environment: production" \
-H "Authorization: Bearer {access_token}"
curl "https://api.pipedream.com/v1/connect/{project_id}/components?app=microsoft_power_bi" \
-H "X-PD-Environment: production" \
-H "Authorization: Bearer {access_token}"
# Connect both accounts to the same external_user_id, then
# configure and invoke either app's tools on that user's behalf.ARCHITECTURE
One user, two connected accounts
Your user connects each account once, under whatever ID they already have in your product. The two stay independent — either can be revoked on its own — and your code reaches both through that one user.
Your product
external_user_id
{external_user_id}Pipedream Connect
Managed identity
Auth · tools · routing
Datadog
Connected account
Microsoft Power BI
Connected account
TOOLS
Datadog tools
The Datadog tools this pairing puts in reach, each one running on your user's own connected account.
Actions top 8 of 13
-
Get Account Info
actionDetect the Datadog region for the connected account. Call this FIRST before any other Datadog tool if you do not already know the region. Returns the region domain (e.g.datadoghq.com) which must be passed as theregionparameter to Search Logs, Search Monitors, Get Metric Data, and all other Datadog tools. See the docsRead-onlyv1.0.2 -
Get Account Region
actionDetect the Datadog region for the connected account by validating the API key against each regional endpoint. Use this to discover the correct region before calling other Datadog actions. See the docsRead-onlyv0.0.1 -
Get Metric Data
actionQuery time-series metric data for analyzing trends and system performance. Query syntax:avg:system.cpu.user{*},sum:requests.count{env:prod} by {host},max:system.mem.used{service:web}. Bothfromandtoare POSIX timestamps in seconds. Use Search Metrics first to discover available metric names. Use Search Hosts to find valid host tags for scoping. After finding anomalies, use Search Logs to investigate related entries. See the docsRead-onlyv1.0.2 -
List Logs
actionGet a list of logs matching a filter query. Uses the GET endpoint with a higher rate limit (3600/hr vs 300/hr). See the docsRead-onlyv0.0.1 -
Post Metric Data
actionPost custom time-series metric data points to Datadog. Data appears in dashboards, monitors, and can be queried via Get Metric Data. Points: JSON object where keys are Unix timestamps (seconds) and values are numeric, e.g.{"1640995200": 1.0}. Use Search Metrics to verify a metric name exists, or post to a new name to create it. This is a WRITE operation that creates or appends data to a metric time series. See the docsWritev1.0.2 -
Search Dashboards
actionList and search Datadog dashboards. Returns dashboard IDs, titles, URLs, and metadata. Dashboard URL:https://app.{region}/dashboard/{id}where region comes from Get Account Info. Use alongside Search Services to find dashboards related to a specific service. See the docsRead-onlyv1.0.2 -
Search Events
actionSearch Datadog events: monitor state changes, deployment markers, error spikes, and infrastructure events. Filter bysources(e.g.nagios,docker),tags(e.g.env:prod,service:web), andpriority(normalorlow). Time range defaults to last 24h (POSIX timestamps in seconds). To investigate a monitor alert, use Search Monitors first, then search events for the relevant time range. Follow up with Search Logs for deeper investigation. See the docsRead-onlyv1.0.2 -
Search Hosts
actionSearch monitored infrastructure hosts. Filter by tag (env:production), name (host:web-01), or partial match. Sort bycpu,iowait,load,status, orapps. Host names from results can scope queries in Get Metric Data (e.g.avg:system.cpu.user{host:web-01}), filter logs in Search Logs (host:web-01), or filter metrics in Search Metrics. Max 1000 results. See the docsRead-onlyv1.0.2
TOOLS
Microsoft Power BI tools
The Microsoft Power BI tools this pairing puts in reach, each one running on your user's own connected account.
Actions top 8 of 15
-
Add Rows to Dataset Table
actionAdds new data rows to the specified table within the specified dataset from My workspace. See the documentationWritev0.0.6 -
Add Rows To Push Dataset
actionAppend rows to a table in a Power BI Push Dataset (streaming / realtime data). Only works for datasets created via the REST API withdefaultMode: Push— these datasets exposeaddRowsAPIEnabled: trueon the object returned by List Datasets. Use List Datasets first to resolve a dataset name →datasetIdand inspect itstablesfor the exacttableName(case-sensitive). PassworkspaceId(from List Workspaces) orworkspaceNameto target a specific workspace, or omit both for My workspace. Rows must match the table's column schema.rowsaccepts either a JSON array ([{...}, {...}]) or a JSON-stringified array. Each row is an object ofcolumnName → value. Common mistakes: (1) case mismatch ontableNamereturns 404 — copy the exact string from the dataset'stablesarray. (2) Sending values that don't match the declared column data type returnsRequestedResourceNotFoundorDMTS_DatasourceHasNoCredentialsError. Push-dataset rows have no individual IDs and cannot be updated or deleted — only appended or bulk-cleared. See the documentationWritev0.0.3 -
Cancel Dataset Refresh
actionCancels a refresh operation for a specified dataset in Power BI. See the documentationWritev0.0.5 -
Create Dataset
actionCreates a new Push Dataset in Power BI. See the documentationWritev0.0.4 -
Execute DAX Query
actionExecute a DAX (Data Analysis Expressions) query against a Power BI dataset (semantic model). This is the primary analytics tool — use it to answer questions about values, aggregates, or filtered rows in a dataset. Use List Datasets first to resolve a dataset name →datasetId. The query must be a single valid DAX expression starting withEVALUATE. Table discovery (standard datasets): For datasets published from Power BI Desktop, the RESTGET /datasets/{id}/tablesendpoint is scoped to push datasets only and will not list tables. UseEVALUATE INFO.TABLES()instead — it returns every table name in the semantic model. Typical agent flow: List Workspaces → List Datasets → Execute DAX Query (EVALUATE INFO.TABLES()) → Execute DAX Query (EVALUATE 'TableName'). Common patterns: • Discover all tables —EVALUATE INFO.TABLES()(use this before querying an unknown dataset) • List all rows of a table —EVALUATE 'Species'• Filter —EVALUATE FILTER('Species', 'Species'[dietType] = "Carnivore")• Top N by column —EVALUATE TOPN(5, 'Species', 'Species'[weightKg], DESC)• Aggregate single value —EVALUATE ROW("Total", SUMX('Species', 'Species'[weightKg]))• Peek at a table's columns —EVALUATE TOPN(0, 'Species')(returns an empty rowset with column names in the response). Limits: max 100,000 rows or 1,000,000 values per query, andDEFINE/multiple-statement queries are not supported via REST. The tenant must have 'Dataset Execute Queries REST API' enabled (admin setting) or the call returns 401/403. PassworkspaceId(from List Workspaces) orworkspaceNameto target a specific workspace, or omit both for My workspace. See the documentationRead-onlyv0.0.4 -
Export Report
actionExport a Power BI report to a file format such as PDF, PPTX, or PNG. Requires a report ID (use List Reports to find it) and defaults to PDF if no format is given. PassworkspaceId(from List Workspaces) orworkspaceNameto target a specific workspace, or omit both for My workspace. Supportedformatvalues depend on the report type: Power BI reports supportPDF,PPTX,PNG. Paginated reports additionally supportCSV,XLSX,DOCX,XML,MHTML. This API is Premium-only: requires the workspace to be backed by Premium capacity, Premium Per User, or Embedded capacity. On shared (free) capacity it returnsFixedCapacityLimitExceeded/ 403. The export is asynchronous — this tool starts the export, then polls until the job reachesSucceededorFailed(orpollTimeoutSecondselapses), then downloads the file and returns it as base64 along with the job metadata. PNG exports only work for single-page reports. For PPTX/PDF, passpages(array of page names, e.g.,["ReportSection", "ReportSection1"]) to limit the export. See the documentationWritev0.0.3 -
Get Dataset Refresh
actionTriggers a refresh operation for a specified Power BI dataset. See the documentationRead-onlyv0.0.3 -
Get Refresh History
actionGet the refresh history for a Power BI dataset. Use List Datasets first to resolve a dataset name →datasetId. PassworkspaceId(from List Workspaces) orworkspaceNameto scope to a specific workspace, or omit both for My workspace. Each entry includesrequestId,refreshType(OnDemand,Scheduled,ViaApi, etc.),startTime,endTime,status(Completed,Failed,Disabled,Cancelled,Unknown—Unknownmeans still in progress), andserviceExceptionJsonon failures. See the documentationRead-onlyv0.0.3
Triggers
-
Dataset Refresh Completed
triggerEmit new event when a dataset refresh operation has completed. See the documentationv0.0.7 -
Dataset Refresh Failed
triggerEmit new event when a dataset refresh operation has failed in Power BI. See the documentationv0.0.7 -
New Dataset Refresh Created
triggerEmit new event when a new dataset refresh operation is created. See the documentationv0.0.4
MULTI-APP
Works with more apps
The combinations customers connect alongside these two — nothing here is limited to a pair.
REFERENCE
Toolkit details
- x-pd-app-slug
- datadog,microsoft_power_bi
- Primary app
- Datadog (datadog)
- Second app
- Microsoft Power BI (microsoft_power_bi)
- Authentication
- API key + OAuth
- Available actions
- 28
- Available triggers
- 4