Power BI

Use the @bijection/connectors/powerbi entrypoint to declare Power BI resources.

Availability

This page describes the pinned source package. Published availability is unestablished for this artifact. Source build and package availability.

Resources and modes

Resource	Mode	Description
Datasets	`pull`	The workspace’s semantic models
Refresh history	`pull`	One dataset’s latest refresh entries
DAX query	`dax`	One fixed DAX query computed by Power BI

Declare a resource in application code, then bind deployment-specific settings and credentials. See typed resources, connections and source inspection.

Datasets

pull: The workspace’s semantic models

The following example matches configuration standard.

import { powerbi } from "@bijection/connectors/powerbi";
export const datasets = powerbi.datasets.pull();

Inferred record types

Resource without an operational record table

Configuration: standard

Case: powerbi/datasets/pull/standard. Connection and resource configuration are declared by this exact case. Credential kind: powerbi. Keep credential material in the private credential inventory.

Setting	Type	Required	Owner
`workspaceId`	string	Yes	Shared connection

Complete configuration contract

{
  "setup": [],
  "resource": {
    "access": {},
    "defaults": {},
    "connector": "powerbi",
    "output": {
      "kind": "single",
      "collection": "datasets"
    },
    "credential_kind": "powerbi",
    "connection_fields": [
      "workspaceId"
    ],
    "address": {
      "kind": "fixed",
      "url": "https://api.powerbi.com"
    }
  },
  "connection_setup": {
    "type": "object",
    "value": {
      "workspaceId": {
        "fieldType": {
          "type": "string"
        },
        "optional": false
      }
    }
  },
  "execution": null
}

Native admission analysis is available for this exact declaration. Collection: datasets

Contract	Meaning
Initial	Enumeration of observed records
Changes	Repeated observations of current records
Deletions	Deletion detection unsupported
Resume	No continuation
Gap	Not applicable
Retention	Unspecified

Complete native profile

{
  "movement": {
    "exchanges": {
      "list": {
        "200": {
          "placement": "retained_bytes",
          "interpretation": "json",
          "projectsBeforeRetention": false,
          "retainedBodyLimitBytes": "524288",
          "fileLimitBytes": null
        },
        "429": {
          "placement": "retained_bytes",
          "interpretation": "opaque",
          "projectsBeforeRetention": false,
          "retainedBodyLimitBytes": "524288",
          "fileLimitBytes": null
        }
      }
    },
    "nativeInputLimitBytes": null,
    "steps": [
      {
        "id": "acquire.1",
        "inputs": [],
        "action": {
          "operation": "acquire",
          "subject": "exchange list",
          "limitBytes": null
        }
      },
      {
        "id": "retain.1",
        "inputs": [
          "acquire.1"
        ],
        "action": {
          "operation": "retain",
          "subject": "acquisition evidence",
          "reason": "recovery",
          "release": "acquisition_custody"
        }
      },
      {
        "id": "interpret.1",
        "inputs": [
          "retain.1"
        ],
        "action": {
          "operation": "interpret",
          "subject": "acquired input",
          "produces": "records"
        }
      },
      {
        "id": "materialize.1",
        "inputs": [
          "interpret.1"
        ],
        "action": {
          "operation": "materialize",
          "subject": "source rows",
          "reason": "serving",
          "release": "replacement"
        }
      },
      {
        "id": "publish.1",
        "inputs": [
          "materialize.1"
        ],
        "action": {
          "operation": "publish",
          "subject": "source rows",
          "visibility": "with_acquisition"
        }
      }
    ]
  },
  "initial": "enumeration",
  "changes": "observations",
  "deletions": "unsupported",
  "resume": "none",
  "retentionMs": null,
  "gap": "not_applicable",
  "limits": {
    "http_response_bytes": "524288"
  },
  "restrictions": [],
  "commands": {}
}

Commands, occurrences and artifacts

{
  "records": {
    "datasets": {
      "protocol": "record_observation",
      "coverage": "records",
      "consistency": "observations",
      "atomicity": "record",
      "history": "observations",
      "recordRefresh": false,
      "reconciliation": false,
      "notifications": false,
      "snapshotMaxRows": null,
      "profile": {
        "movement": {
          "exchanges": {
            "list": {
              "200": {
                "placement": "retained_bytes",
                "interpretation": "json",
                "projectsBeforeRetention": false,
                "retainedBodyLimitBytes": "524288",
                "fileLimitBytes": null
              },
              "429": {
                "placement": "retained_bytes",
                "interpretation": "opaque",
                "projectsBeforeRetention": false,
                "retainedBodyLimitBytes": "524288",
                "fileLimitBytes": null
              }
            }
          },
          "nativeInputLimitBytes": null,
          "steps": [
            {
              "id": "acquire.1",
              "inputs": [],
              "action": {
                "operation": "acquire",
                "subject": "exchange list",
                "limitBytes": null
              }
            },
            {
              "id": "retain.1",
              "inputs": [
                "acquire.1"
              ],
              "action": {
                "operation": "retain",
                "subject": "acquisition evidence",
                "reason": "recovery",
                "release": "acquisition_custody"
              }
            },
            {
              "id": "interpret.1",
              "inputs": [
                "retain.1"
              ],
              "action": {
                "operation": "interpret",
                "subject": "acquired input",
                "produces": "records"
              }
            },
            {
              "id": "materialize.1",
              "inputs": [
                "interpret.1"
              ],
              "action": {
                "operation": "materialize",
                "subject": "source rows",
                "reason": "serving",
                "release": "replacement"
              }
            },
            {
              "id": "publish.1",
              "inputs": [
                "materialize.1"
              ],
              "action": {
                "operation": "publish",
                "subject": "source rows",
                "visibility": "with_acquisition"
              }
            }
          ]
        },
        "initial": "enumeration",
        "changes": "observations",
        "deletions": "unsupported",
        "resume": "none",
        "retentionMs": null,
        "gap": "not_applicable",
        "limits": {
          "http_response_bytes": "524288"
        },
        "restrictions": [],
        "commands": {}
      }
    }
  },
  "occurrences": null,
  "artifacts": {
    "raw_archive": false,
    "native_file_transfer_limit_bytes": null,
    "external_versions": false,
    "files": {}
  },
  "commands": {}
}

Recorded checks

Requirement	Scope	Evidence	Result
page-publication-recovery	{“kind”:“collection”,“name”:“datasets”}	No check exercises this packaged Power BI declaration against Power BI; it is declared from Microsoft Learn and has not run or been qualified.	Execution result unavailable
backoff-stated-wait	{“kind”:“connection”}	No check exercises this packaged Power BI declaration against Power BI; it is declared from Microsoft Learn and has not run or been qualified.	Execution result unavailable
identity-account	{“kind”:“connection”}	No check exercises this packaged Power BI declaration against Power BI; it is declared from Microsoft Learn and has not run or been qualified.	Execution result unavailable

Hosted qualification: unestablished for this catalog configuration. Installed connections report their own identity, authority and current status.

Refresh history

pull: One dataset’s latest refresh entries

The following example matches configuration standard.

import { powerbi } from "@bijection/connectors/powerbi";
export const refreshes = powerbi.refreshes.pull({
  dataset: "cfafbeb1-8037-4d0c-896e-a46fb27ff229",
});

Inferred record types

Resource without an operational record table

Configuration: standard

Case: powerbi/refreshes/pull/standard. Connection and resource configuration are declared by this exact case. Credential kind: powerbi. Keep credential material in the private credential inventory.

Setting	Type	Required	Owner
`workspaceId`	string	Yes	Shared connection

Complete configuration contract

{
  "setup": [],
  "resource": {
    "access": {},
    "defaults": {},
    "connector": "powerbi",
    "output": {
      "kind": "single",
      "collection": "refreshes"
    },
    "credential_kind": "powerbi",
    "connection_fields": [
      "workspaceId"
    ],
    "address": {
      "kind": "fixed",
      "url": "https://api.powerbi.com"
    }
  },
  "connection_setup": {
    "type": "object",
    "value": {
      "workspaceId": {
        "fieldType": {
          "type": "string"
        },
        "optional": false
      }
    }
  },
  "execution": null
}

Native admission analysis is available for this exact declaration. Collection: refreshes

Contract	Meaning
Initial	Enumeration of observed records
Changes	Repeated observations of current records
Deletions	Deletion detection unsupported
Resume	No continuation
Gap	Not applicable
Retention	Unspecified

Complete native profile

{
  "movement": {
    "exchanges": {
      "history": {
        "200": {
          "placement": "retained_bytes",
          "interpretation": "json",
          "projectsBeforeRetention": false,
          "retainedBodyLimitBytes": "524288",
          "fileLimitBytes": null
        },
        "429": {
          "placement": "retained_bytes",
          "interpretation": "opaque",
          "projectsBeforeRetention": false,
          "retainedBodyLimitBytes": "524288",
          "fileLimitBytes": null
        }
      }
    },
    "nativeInputLimitBytes": null,
    "steps": [
      {
        "id": "acquire.1",
        "inputs": [],
        "action": {
          "operation": "acquire",
          "subject": "exchange history",
          "limitBytes": null
        }
      },
      {
        "id": "retain.1",
        "inputs": [
          "acquire.1"
        ],
        "action": {
          "operation": "retain",
          "subject": "acquisition evidence",
          "reason": "recovery",
          "release": "acquisition_custody"
        }
      },
      {
        "id": "interpret.1",
        "inputs": [
          "retain.1"
        ],
        "action": {
          "operation": "interpret",
          "subject": "acquired input",
          "produces": "records"
        }
      },
      {
        "id": "materialize.1",
        "inputs": [
          "interpret.1"
        ],
        "action": {
          "operation": "materialize",
          "subject": "source rows",
          "reason": "serving",
          "release": "replacement"
        }
      },
      {
        "id": "publish.1",
        "inputs": [
          "materialize.1"
        ],
        "action": {
          "operation": "publish",
          "subject": "source rows",
          "visibility": "with_acquisition"
        }
      }
    ]
  },
  "initial": "enumeration",
  "changes": "observations",
  "deletions": "unsupported",
  "resume": "none",
  "retentionMs": null,
  "gap": "not_applicable",
  "limits": {
    "http_response_bytes": "524288"
  },
  "restrictions": [],
  "commands": {}
}

Commands, occurrences and artifacts

{
  "records": {
    "refreshes": {
      "protocol": "record_observation",
      "coverage": "records",
      "consistency": "observations",
      "atomicity": "record",
      "history": "observations",
      "recordRefresh": false,
      "reconciliation": false,
      "notifications": false,
      "snapshotMaxRows": null,
      "profile": {
        "movement": {
          "exchanges": {
            "history": {
              "200": {
                "placement": "retained_bytes",
                "interpretation": "json",
                "projectsBeforeRetention": false,
                "retainedBodyLimitBytes": "524288",
                "fileLimitBytes": null
              },
              "429": {
                "placement": "retained_bytes",
                "interpretation": "opaque",
                "projectsBeforeRetention": false,
                "retainedBodyLimitBytes": "524288",
                "fileLimitBytes": null
              }
            }
          },
          "nativeInputLimitBytes": null,
          "steps": [
            {
              "id": "acquire.1",
              "inputs": [],
              "action": {
                "operation": "acquire",
                "subject": "exchange history",
                "limitBytes": null
              }
            },
            {
              "id": "retain.1",
              "inputs": [
                "acquire.1"
              ],
              "action": {
                "operation": "retain",
                "subject": "acquisition evidence",
                "reason": "recovery",
                "release": "acquisition_custody"
              }
            },
            {
              "id": "interpret.1",
              "inputs": [
                "retain.1"
              ],
              "action": {
                "operation": "interpret",
                "subject": "acquired input",
                "produces": "records"
              }
            },
            {
              "id": "materialize.1",
              "inputs": [
                "interpret.1"
              ],
              "action": {
                "operation": "materialize",
                "subject": "source rows",
                "reason": "serving",
                "release": "replacement"
              }
            },
            {
              "id": "publish.1",
              "inputs": [
                "materialize.1"
              ],
              "action": {
                "operation": "publish",
                "subject": "source rows",
                "visibility": "with_acquisition"
              }
            }
          ]
        },
        "initial": "enumeration",
        "changes": "observations",
        "deletions": "unsupported",
        "resume": "none",
        "retentionMs": null,
        "gap": "not_applicable",
        "limits": {
          "http_response_bytes": "524288"
        },
        "restrictions": [],
        "commands": {}
      }
    }
  },
  "occurrences": null,
  "artifacts": {
    "raw_archive": false,
    "native_file_transfer_limit_bytes": null,
    "external_versions": false,
    "files": {}
  },
  "commands": {}
}

Recorded checks

Requirement	Scope	Evidence	Result
page-publication-recovery	{“kind”:“collection”,“name”:“refreshes”}	No check exercises this packaged Power BI declaration against Power BI; it is declared from Microsoft Learn and has not run or been qualified.	Execution result unavailable
backoff-stated-wait	{“kind”:“connection”}	No check exercises this packaged Power BI declaration against Power BI; it is declared from Microsoft Learn and has not run or been qualified.	Execution result unavailable
identity-account	{“kind”:“connection”}	No check exercises this packaged Power BI declaration against Power BI; it is declared from Microsoft Learn and has not run or been qualified.	Execution result unavailable

Hosted qualification: unestablished for this catalog configuration. Installed connections report their own identity, authority and current status.

DAX query

dax: One fixed DAX query computed by Power BI

The following example matches configuration standard.

import { powerbi } from "@bijection/connectors/powerbi";
export const salesByYear = powerbi.query.dax({
  dataset: "cfafbeb1-8037-4d0c-896e-a46fb27ff229",
  dax: "EVALUATE SUMMARIZECOLUMNS('Date'[Year], \"Sales\", [Total Sales])",
  columns: {
    year: { column: "Date[Year]", type: "integer" },
    sales: { column: "[Sales]", type: "number" },
  },
  key: ["year"],
});

Inferred record types

Resource without an operational record table

Configuration: standard

Case: powerbi/query/dax/standard. Connection and resource configuration are declared by this exact case. Credential kind: powerbi. Keep credential material in the private credential inventory.

Setting	Type	Required	Owner
`workspaceId`	string	Yes	Shared connection

Complete configuration contract

{
  "setup": [],
  "resource": {
    "access": {},
    "defaults": {},
    "connector": "powerbi",
    "output": {
      "kind": "single",
      "collection": "rows"
    },
    "credential_kind": "powerbi",
    "connection_fields": [
      "workspaceId"
    ],
    "address": {
      "kind": "fixed",
      "url": "https://api.powerbi.com"
    }
  },
  "connection_setup": {
    "type": "object",
    "value": {
      "workspaceId": {
        "fieldType": {
          "type": "string"
        },
        "optional": false
      }
    }
  },
  "execution": null
}

Native admission analysis is available for this exact declaration. Collection: rows

Contract	Meaning
Initial	Enumeration of observed records
Changes	Repeated observations of current records
Deletions	Deletion detection unsupported
Resume	No continuation
Gap	Not applicable
Retention	Unspecified

Complete native profile

{
  "movement": {
    "exchanges": {
      "query": {
        "200": {
          "placement": "retained_bytes",
          "interpretation": "json",
          "projectsBeforeRetention": false,
          "retainedBodyLimitBytes": "524288",
          "fileLimitBytes": null
        },
        "400": {
          "placement": "retained_bytes",
          "interpretation": "opaque",
          "projectsBeforeRetention": false,
          "retainedBodyLimitBytes": "524288",
          "fileLimitBytes": null
        },
        "429": {
          "placement": "retained_bytes",
          "interpretation": "opaque",
          "projectsBeforeRetention": false,
          "retainedBodyLimitBytes": "524288",
          "fileLimitBytes": null
        }
      }
    },
    "nativeInputLimitBytes": null,
    "steps": [
      {
        "id": "acquire.1",
        "inputs": [],
        "action": {
          "operation": "acquire",
          "subject": "exchange query",
          "limitBytes": null
        }
      },
      {
        "id": "retain.1",
        "inputs": [
          "acquire.1"
        ],
        "action": {
          "operation": "retain",
          "subject": "acquisition evidence",
          "reason": "recovery",
          "release": "acquisition_custody"
        }
      },
      {
        "id": "interpret.1",
        "inputs": [
          "retain.1"
        ],
        "action": {
          "operation": "interpret",
          "subject": "acquired input",
          "produces": "records"
        }
      },
      {
        "id": "materialize.1",
        "inputs": [
          "interpret.1"
        ],
        "action": {
          "operation": "materialize",
          "subject": "source rows",
          "reason": "serving",
          "release": "replacement"
        }
      },
      {
        "id": "publish.1",
        "inputs": [
          "materialize.1"
        ],
        "action": {
          "operation": "publish",
          "subject": "source rows",
          "visibility": "with_acquisition"
        }
      }
    ]
  },
  "initial": "enumeration",
  "changes": "observations",
  "deletions": "unsupported",
  "resume": "none",
  "retentionMs": null,
  "gap": "not_applicable",
  "limits": {
    "http_response_bytes": "524288"
  },
  "restrictions": [],
  "commands": {}
}

Commands, occurrences and artifacts

{
  "records": {
    "rows": {
      "protocol": "record_observation",
      "coverage": "records",
      "consistency": "observations",
      "atomicity": "record",
      "history": "observations",
      "recordRefresh": false,
      "reconciliation": false,
      "notifications": false,
      "snapshotMaxRows": null,
      "profile": {
        "movement": {
          "exchanges": {
            "query": {
              "200": {
                "placement": "retained_bytes",
                "interpretation": "json",
                "projectsBeforeRetention": false,
                "retainedBodyLimitBytes": "524288",
                "fileLimitBytes": null
              },
              "400": {
                "placement": "retained_bytes",
                "interpretation": "opaque",
                "projectsBeforeRetention": false,
                "retainedBodyLimitBytes": "524288",
                "fileLimitBytes": null
              },
              "429": {
                "placement": "retained_bytes",
                "interpretation": "opaque",
                "projectsBeforeRetention": false,
                "retainedBodyLimitBytes": "524288",
                "fileLimitBytes": null
              }
            }
          },
          "nativeInputLimitBytes": null,
          "steps": [
            {
              "id": "acquire.1",
              "inputs": [],
              "action": {
                "operation": "acquire",
                "subject": "exchange query",
                "limitBytes": null
              }
            },
            {
              "id": "retain.1",
              "inputs": [
                "acquire.1"
              ],
              "action": {
                "operation": "retain",
                "subject": "acquisition evidence",
                "reason": "recovery",
                "release": "acquisition_custody"
              }
            },
            {
              "id": "interpret.1",
              "inputs": [
                "retain.1"
              ],
              "action": {
                "operation": "interpret",
                "subject": "acquired input",
                "produces": "records"
              }
            },
            {
              "id": "materialize.1",
              "inputs": [
                "interpret.1"
              ],
              "action": {
                "operation": "materialize",
                "subject": "source rows",
                "reason": "serving",
                "release": "replacement"
              }
            },
            {
              "id": "publish.1",
              "inputs": [
                "materialize.1"
              ],
              "action": {
                "operation": "publish",
                "subject": "source rows",
                "visibility": "with_acquisition"
              }
            }
          ]
        },
        "initial": "enumeration",
        "changes": "observations",
        "deletions": "unsupported",
        "resume": "none",
        "retentionMs": null,
        "gap": "not_applicable",
        "limits": {
          "http_response_bytes": "524288"
        },
        "restrictions": [],
        "commands": {}
      }
    }
  },
  "occurrences": null,
  "artifacts": {
    "raw_archive": false,
    "native_file_transfer_limit_bytes": null,
    "external_versions": false,
    "files": {}
  },
  "commands": {}
}

Recorded checks

Requirement	Scope	Evidence	Result
page-publication-recovery	{“kind”:“collection”,“name”:“rows”}	No check exercises this packaged Power BI declaration against Power BI; it is declared from Microsoft Learn and has not run or been qualified.	Execution result unavailable
backoff-stated-wait	{“kind”:“connection”}	No check exercises this packaged Power BI declaration against Power BI; it is declared from Microsoft Learn and has not run or been qualified.	Execution result unavailable
identity-account	{“kind”:“connection”}	No check exercises this packaged Power BI declaration against Power BI; it is declared from Microsoft Learn and has not run or been qualified.	Execution result unavailable

Hosted qualification: unestablished for this catalog configuration. Installed connections report their own identity, authority and current status.

Provider guidance

Compiled declaration examples and configuration details are published in the connector reference. Read-only access to Power BI semantic models through the Power BI REST API (https://api.powerbi.com/v1.0/myorg/). Nothing here refreshes, edits or deletes a dataset. Power BI computes every query; Bijection reads the answer. The connection is anchored to one workspace (workspaceId setup): GET groups/{workspaceId} must answer that workspace’s id, which is the identity. The credential is the deployment’s envelope: an Entra client credentials grant for a service principal (scope https://analysis.windows.net/powerbi/api/.default) or a bearer. Power BI answers throttling with 429 and Retry-After seconds. datasets.pull reads groups/{id}/datasets once; the reference states no paging and no completeness, so it claims no coverage. A caller with only Read permission receives a subset of properties, so a null field means “not returned”. A dataset missing from a later listing is not withdrawn. refreshes.pull reads one dataset’s latest $top (default and maximum 60) refresh entries, keyed by requestId. An entry is Unknown with no endTime while it runs, then Completed, Failed (with serviceExceptionJson) or Disabled. It requires Write permission on the dataset. query.dax posts one fixed DAX query to executeQueries with includeNulls: true. A DAX result has no key, so the caller declares the key columns; a repeated or null key refuses the page. Numbers are JSON doubles, so Decimal and Currency values are not exact through this API; dates arrive as strings. Documented limits: one query and one table per request, 100,000 rows or 1,000,000 values, 15 MB, 120 query requests per minute per user, the tenant setting “Dataset Execute Queries REST API”, no service principals on datasets with RLS or SSO. A result over the row limit answers 200 with limited rows and an error, which this recipe refuses. The host retains at most 512 KiB per response, so keep results small. The XMLA endpoint is not built: Microsoft documents it only through the Analysis Services client libraries. Nothing here has run against Power BI or been qualified.

Provider references

Provider references and prerequisites are maintained in the connector guidance above. No separate provider-documentation review date is recorded.

Source and evidence

Canonical connector source, native analysis and check receipts. Connector artifact: 905888ea276a2a28e36981a79e8142b2547ea451c3e63162cb6915ad4a7d1305. The resource declaration examples above are compiled and compared with exact catalog declarations. Recorded checks apply only to their source, declaration and runtime identities. Configure a connection and inspect its status to establish deployment-specific readiness.

Get Started

Use-case atlas

Platform

Data and Operations

Guides

Client Libraries

Tools

API Reference

Availability

Resources and modes

Datasets

pull: The workspace’s semantic models

Configuration: standard

Refresh history

pull: One dataset’s latest refresh entries

Configuration: standard

DAX query

dax: One fixed DAX query computed by Power BI

Configuration: standard

Provider guidance

Provider references

Source and evidence

​Availability

​Resources and modes

​Datasets

​pull: The workspace’s semantic models

​Configuration: standard

​Refresh history

​pull: One dataset’s latest refresh entries

​Configuration: standard

​DAX query

​dax: One fixed DAX query computed by Power BI

​Configuration: standard

​Provider guidance

​Provider references

​Source and evidence

Availability

Resources and modes

Datasets

pull: The workspace’s semantic models

Configuration: standard

Refresh history

pull: One dataset’s latest refresh entries

Configuration: standard

DAX query

dax: One fixed DAX query computed by Power BI

Configuration: standard

Provider guidance

Provider references

Source and evidence