> This page is for Agent Handler. > For clean Markdown of any page, append .md to the page URL. > For a complete documentation index, see https://docs.merge.dev/llms.txt. > For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://docs.merge.dev/_mcp/server. # Microsoft Power BI **Authentication:** OAuth or access token. See [Magic Link](/merge-agent-handler/features/magic-link) for the runtime auth flow, or [Application credentials](/merge-agent-handler/admin-setup/add-oauth-credentials) to bring your own OAuth app. ## Sample use cases * Refresh the `Sales Pipeline` semantic model and check the refresh history for failures * List every report in the `Finance` workspace and who has access to the workspace * Push rows into a push dataset for a live operations dashboard ## Available Tools #### list_admin_workspaces List every workspace in the tenant, including ones the account is not a member of. Requires the Fabric Administrator... #### list_admin_reports List every report in the tenant, across all workspaces. Requires the Fabric Administrator role, not just the... #### list_admin_datasets List every semantic model in the tenant, across all workspaces. Requires the Fabric Administrator role, not just the... #### list_admin_dashboards List every dashboard in the tenant, across all workspaces. Requires the Fabric Administrator role, not just the... #### list_admin_dataflows List every dataflow in the tenant, across all workspaces. Requires the Fabric Administrator role, not just the... #### list_apps List the Power BI apps the connected account can open. Apps are published, read-only collections of reports and... #### get_app Get one Power BI app by ID. Use list_apps to find app_id. #### list_app_reports List the reports published inside a Power BI app. These are separate from the reports in a workspace; use... #### list_app_dashboards List the dashboards published inside a Power BI app. These are separate from the dashboards in a workspace; use... #### list_dashboards List the dashboards in a Power BI workspace. Returns every dashboard in one response; the API does not page this... #### get_dashboard Get one dashboard by ID. Use list_dashboards to find dashboard_id. #### create_dashboard Create an empty dashboard in a Power BI workspace. Tiles are pinned from reports in the Power BI UI; the API cannot... #### list_dashboard_tiles List the tiles pinned to a dashboard, including the report and semantic model behind each one. Use list_dashboards... #### list_dataflows List the Power BI (Gen1) dataflows in a workspace. Fabric Dataflow Gen2 is a different item type served by a... #### get_dataflow Get a Power BI (Gen1) dataflow's stored definition, containing its entities and Power Query expressions. Returns the... #### list_datasets List the semantic models (datasets) in a Power BI workspace. Returns every model in one response; the API does not... #### get_dataset Get one semantic model by ID. Use list_datasets to find dataset_id. #### delete_dataset Delete a semantic model and every report built on it. This cannot be undone. Use list_datasets to find dataset_id. #### refresh_dataset Start a refresh of a semantic model. Returns as soon as the refresh is queued, not when it finishes; poll... #### get_refresh_history List past and in-progress refreshes of a semantic model, newest first. A status of 'Unknown' means the refresh is... #### get_dataset_datasources List the data sources a semantic model reads from, including the gateway serving each one. Use list_datasets to find... #### list_gateways List the on-premises data gateways the connected account can administer. A gateway connects Power BI to data sources... #### get_gateway Get one on-premises data gateway by ID. Use list_gateways to find gateway_id. #### list_gateway_datasources List the data sources bound to an on-premises data gateway. Use this to see what a gateway serves before changing... #### list_imports List the.pbix and Excel imports performed into a Power BI workspace, with the state of each. Importing a file is how\... #### get_import Get one import by ID to check its progress. import_state reads 'Publishing' while it runs and 'Succeeded' when the... #### create_push_dataset Create a push semantic model from a table schema, with no.pbix file. This is the only way to create a semantic model... #### push_rows Append rows to a table in a push semantic model. Row keys must match the column names the model was created with... #### truncate_table Delete every row from a table in a push semantic model, leaving the table and its schema in place. This cannot be... #### list_dataset_tables List the table names in a push semantic model. The API returns names only, not the columns each table was created... #### list_reports List the reports in a Power BI workspace. Returns every report in one response; the API does not page this endpoint... #### get_report Get one report by ID, including the semantic model it reads from. Use list_reports to find report_id. #### delete_report Delete a report from a Power BI workspace. This does not delete the semantic model behind it. Use list_reports to... #### clone_report Copy a report, optionally into another workspace or onto another semantic model. This is the only way to create a... #### list_workspaces List the Power BI workspaces the connected account can open. Supports an OData filter_query to narrow results... #### get_workspace Get one Power BI workspace by ID. Use list_workspaces to find workspace_id. #### create_workspace Create a Power BI workspace. The name must be unique in the tenant. Returns the new workspace including its ID... #### delete_workspace Delete a Power BI workspace and everything inside it. This cannot be undone. Use list_workspaces to find workspace_id. #### list_workspace_users List the users, groups and service principals with access to a Power BI workspace, and the access level each holds... #### add_workspace_user Grant a user, group or service principal access to a Power BI workspace. Pass email_address for a person, or... #### remove_workspace_user Revoke a principal's access to a Power BI workspace. Use list_workspace_users to find the exact email address or...