Power BI
Fuld Power BI-styring via MCP: arbejdsområder, rapporter, datasæt, dashboards, dataflows, apps, gateways, kapaciteter og deployment pipelines. Kør DAX, genindlæs, eksporter og deploy via Microsoft OAuth.
Overblik
Forbind Power BI-arbejdsområder, rapporter, datasæt, dashboards, dataflows, apps, gateways, kapaciteter og deployment pipelines til AI-klienter via Power BI REST API. Kør DAX-forespørgsler, genindlæs modeller, eksporter rapporter, administrer adgang og deploy mellem pipeline-stadier.
Forudsætninger
- En Microsoft-konto med adgang til Power BI (
app.powerbi.com) - Power BI Pro, Premium Per User (PPU) eller adgang til arbejdsområder på Premium-kapacitet
- En stackgate.ai-konto
- For arbejds-/skolekonti kan IT-administratorsamtykke være påkrævet for delegerede Power BI-tilladelser
Credentials
- Log ind på stackgate.ai.
- Gå til Mine integrationer og åbn Power BI.
- Klik Aktivér, derefter Log ind med Microsoft.
- Gennemfør Microsoft OAuth med den konto, der har Power BI-adgang.
- Efter forbindelse kan du bruge Rediger værktøjsadgang til at begrænse Read vs Write.
Arbejdskonti kan kræve, at din IT-administrator giver tenantsamtykke for stackgate.ai-appen i Microsoft Entra, før forbindelsen lykkes. Hvis værktøjer returnerer 401/403 efter en hub-opdatering med nye scopes, genforbind Power BI så Microsoft udsteder et token med de nye delegerede tilladelser.
Power BI er en separat forbindelse fra Outlook Mail og Outlook Calendar — aktivér og forbind hver integration uafhængigt.
Brug med AI-klienter
- Dedikeret endpoint:
POST /mcp/power-bimed Sanctum bearer token - Private gateway: én config til alle integrationer — brug
power-bi__*-navngivne værktøjer
Se Dokumentation for HTTP-autentificering og opsætning af private gateway.
Muligheder
MCP-serveren eksponerer workspace-scoped Power BI REST API'er (ikke tenant-admin API'er):
- Arbejdsområder: list/get/opret/opdater/slet, brugere
- Rapporter: sider, datakilder, klon, slet, rebind, eksport til fil, opdater indhold
- Datasæt: DAX executeQueries, refresh/historik/plan, parametre, datakilder, brugere, gateways, take over, push-dataset rækker
- Dashboards: tiles, opret/slet, klon tiles
- Dataflows: datakilder, transaktioner, refresh, annuller, slet
- Apps, gateways, kapaciteter, deployment pipelines, imports, available features
Tenant Admin-API'er og embed-token-API'er er bevidst uden for scope.
Fejlfinding
- Admin-godkendelse påkrævet — bed din IT-administrator om tenantsamtykke for stackgate.ai og tilføj delegerede Power BI Service-tilladelser i Microsoft Entra.
- Auth-fejl / manglende nye værktøjer — genforbind Power BI fra Mine integrationer for at opdatere scopes.
- 403 på et arbejdsområde — den forbundne konto mangler muligvis adgang til arbejdsområdet i Power BI.
- execute_dataset_query fejler — din Power BI-administrator skal muligvis aktivere Dataset Execute Queries REST API under Integrationsindstillinger i Power BI-administrationsportalen.
- DAX-hastighedsgrænser — Power BI tillader 120 executeQueries-kald pr. minut pr. bruger.
- Genindlæsningsgrænse på shared capacity — op til otte datasæt-genindlæsninger pr. dag inklusive planlagte genindlæsninger.
- Eksport til fil — poll
get_report_export_statusindtil Succeeded, og download derefter fraresourceLocation.
Tilgængelige værktøjer
-
list_workspaces
List Power BI-arbejdsområder den forbundne konto har adgang til.
-
get_workspace
Get metadata for a Power BI workspace by ID.
-
create_workspace
Opret et nyt Power BI-arbejdsområde.
-
update_workspace
Update a Power BI workspace name or default dataset storage format.
-
delete_workspace
Delete a Power BI workspace. The workspace must be empty.
-
list_workspace_users
List brugere, grupper og apps med adgang til et Power BI-arbejdsområde.
-
add_workspace_user
Grant a user, group, or app access to a Power BI workspace.
-
update_workspace_user
Update a principal access right in a Power BI workspace.
-
remove_workspace_user
Remove a user from a Power BI workspace by email address.
-
list_reports
List reports in a Power BI workspace.
-
get_report
Get a Power BI report by workspace and report ID.
-
list_report_pages
List sider i en Power BI-rapport.
-
get_report_page
Get a single page from a Power BI report by page name.
-
list_report_datasources
List datasources for a Power BI report (typically paginated/RDL reports).
-
clone_report
Clone a Power BI report within or across workspaces.
-
delete_report
Delete a Power BI report from a workspace.
-
rebind_report
Rebind a Power BI report to a different dataset.
-
export_report_to_file
Start asynkron eksport af en Power BI-rapport til PDF, PPTX eller PNG.
-
get_report_export_status
Get status of a report export-to-file job. When Succeeded, download from resourceLocation.
-
update_report_content
Update report content from another existing report. Pass payload with sourceType ExistingReport and sourceReport {sourceReportId, sourceWorkspaceId}.
-
list_datasets
List semantic model datasets in a Power BI workspace.
-
get_dataset
Get a Power BI dataset by workspace and dataset ID.
-
list_dataset_datasources
List datasources bound to a Power BI dataset.
-
list_dataset_parameters
List parameters for a Power BI dataset.
-
get_dataset_refresh_history
Hent genindlæsningshistorik for et Power BI-datasæt.
-
get_dataset_refresh_execution_details
Get execution details for a specific dataset refresh request.
-
get_dataset_refresh_schedule
Get the scheduled refresh settings for a Power BI dataset.
-
get_dataset_direct_query_refresh_schedule
Get the DirectQuery/LiveConnection refresh schedule for a Power BI dataset.
-
list_dataset_users
List users with access to a Power BI dataset in a workspace.
-
discover_dataset_gateways
Discover gateways that can be bound to a Power BI dataset.
-
execute_dataset_query
Kør en DAX-forespørgsel mod et Power BI-datasæt (ét query pr. kald; 120 forespørgsler/min pr. bruger).
-
refresh_dataset
Udløs genindlæsning af et Power BI-datasæt. Shared capacity tillader op til otte genindlæsninger pr. dag.
-
cancel_dataset_refresh
Cancel an in-progress enhanced refresh for a Power BI dataset.
-
update_dataset
Update dataset properties such as target storage mode.
-
delete_dataset
Delete a Power BI dataset from a workspace.
-
update_dataset_parameters
Update dataset parameter values.
-
update_dataset_datasources
Update dataset datasource connection details.
-
update_dataset_refresh_schedule
Update the scheduled refresh settings for a Power BI dataset.
-
take_over_dataset
Transfer dataset ownership to the connected user in a workspace.
-
list_dashboards
List dashboards in a Power BI workspace.
-
get_dashboard
Get a Power BI dashboard by workspace and dashboard ID.
-
list_dashboard_tiles
List tiles on a Power BI dashboard.
-
get_dashboard_tile
Get a tile on a Power BI dashboard.
-
create_dashboard
Create an empty dashboard in a Power BI workspace.
-
delete_dashboard
Delete a Power BI dashboard from a workspace.
-
clone_dashboard_tile
Clone a dashboard tile to the same or another dashboard/workspace/report/dataset.
-
list_dataflows
List dataflows i et Power BI-arbejdsområde.
-
get_dataflow
Export/get a Power BI dataflow definition JSON from a workspace.
-
list_dataflow_datasources
List datasources for a Power BI dataflow.
-
list_dataflow_transactions
List transactions for a Power BI dataflow.
-
list_upstream_dataflows
List upstream dataflows for a Power BI dataflow in a workspace.
-
refresh_dataflow
Trigger a refresh for a Power BI dataflow.
-
delete_dataflow
Delete a Power BI dataflow from a workspace.
-
cancel_dataflow_transaction
Cancel a dataflow transaction in a workspace.
-
list_apps
List Power BI-apps installeret for den forbundne bruger.
-
get_app
Get a Power BI app by ID.
-
list_app_reports
List reports in a Power BI app.
-
list_app_dashboards
List dashboards in a Power BI app.
-
list_app_tiles
List tiles from a dashboard inside a Power BI app.
-
list_gateways
List on-premises data gateways den forbundne bruger kan administrere.
-
get_gateway
Get an on-premises data gateway by ID.
-
list_gateway_datasources
List datasources on an on-premises data gateway.
-
get_gateway_datasource
Get a datasource on an on-premises data gateway.
-
get_gateway_datasource_status
Get connectivity status for a gateway datasource.
-
list_gateway_datasource_users
List users with access to a gateway datasource.
-
list_capacities
List Power BI capacities accessible to the connected user.
-
assign_workspace_to_capacity
Assign a Power BI workspace to a capacity, or pass empty capacity_id to unassign shared capacity.
-
get_workspace_capacity_assignment_status
Get capacity assignment status for a Power BI workspace.
-
list_capacity_refreshables
List refreshables across capacities the user can access.
-
list_pipelines
List Power BI deployment pipelines den forbundne bruger har adgang til.
-
get_pipeline
Get a Power BI deployment pipeline by ID.
-
list_pipeline_stages
List stages in a Power BI deployment pipeline.
-
list_pipeline_stage_artifacts
List artifacts assigned to a deployment pipeline stage.
-
list_pipeline_operations
List recent operations for a Power BI deployment pipeline.
-
get_pipeline_operation
Get details for a Power BI deployment pipeline operation.
-
deploy_pipeline_all
Deploy alle understøttede artefakter fra ét pipeline-stadie til det næste.
-
deploy_pipeline_selective
Selectively deploy artifacts between Power BI pipeline stages. Pass the full SelectiveDeployRequest as payload.
-
assign_workspace_to_pipeline
Assign a workspace to a deployment pipeline stage.
-
unassign_workspace_from_pipeline
Unassign the workspace from a deployment pipeline stage.
-
list_imports
List import jobs in a Power BI workspace.
-
get_import
Get an import job in a Power BI workspace.
-
list_available_features
List available Power BI features for the connected user.
-
refresh_user_permissions
Refresh the Power BI permissions cache for the connected user after workspace access changes.
-
list_push_dataset_tables
List tables in a push dataset within a workspace.
-
push_dataset_rows
Push rows into a push-dataset table. Pass rows as an array of objects.
-
delete_push_dataset_rows
Delete all rows from a push-dataset table.
MCP-endpoint:
https://stackgate.ai/mcp/power-bi
(HTTP) eller via
private gateway.