Integration · Company data

Connect Claude & ChatGPT to Microsoft Power BI

Ask your AI which reports sit in a workspace, whether last night's refresh worked, or what a number in a dataset is. It can list workspaces, datasets, reports, report pages, dashboards and tiles, run read-only DAX queries against a dataset, start a data refresh and add rows to a push dataset.

Connect Microsoft Power BI free

Free plan, no credit card. Takes about a minute.

Try asking

“Which workspaces do I have access to, and what reports are in Sales?”
The AI lists your workspaces, finds Sales and lists the reports in it with their web links.
“Did the Finance dataset refresh succeed last night?”
It reads the dataset's refresh history and tells you the status and time of the latest refreshes.
“Refresh the Finance dataset and email me if it fails.”
It starts a data refresh of the dataset with the MailOnFailure notification option.

What your AI can do

Workspaces and reports

List workspaces and your My workspace, read reports with their web URL and dataset, and list report pages, dashboards and tiles.

Datasets and DAX queries

List and read datasets (semantic models), and run read-only DAX queries to get the numbers behind your reports.

Refreshes and push data

Start a data refresh, check the refresh history, list the tables of a push dataset and add rows to them.

“What was total revenue per region last month in the Sales dataset?”
It runs a read-only DAX query against the dataset and returns the rows it gets back.
“Which pages does the Management report have?”
It finds the report in the workspace and lists its pages.
“Add today's three new orders to the push dataset's Orders table.”
It adds the rows to the table in the push dataset, keyed by column name.

223 tools for Microsoft Power BI

These tools are switched on when you connect. You can switch any of them off, or require your approval before it runs.

add_dataset_rowsChanges dataAdd rows to a table in a push dataset by group_id, dataset_id and table_name. Pass rows as a list of objects keyed by column name.
attach_group_to_capacityChanges dataAssign a group (group id). API summary: Assigns the specified workspace to the specified capacity.
attach_group_to_dataflow_storageChanges dataAssign a group (group id). API summary: Assigns the specified workspace to the specified dataflow storage account.
attach_stage_workspaceChanges dataAssign a stage (stage order). API summary: Assigns the specified workspace to the specified deployment pipeline stage.
attach_ticket_to_capacityChanges dataAssign a ticket. API summary: Assigns My workspace to the specified capacity.
cancel_paymentDeletesCancel a payment (transaction id). Destructive action; may require approval. API summary: Attempts to cancel the specified transactions.
create_dashboardChanges dataCreate a new dashboard. Required: name. API summary: Creates a new empty dashboard in My workspace.
create_dashboard_generate_tokenDeletesCreate a new generate token for a dashboard. Destructive action; may require approval. API summary: Generates an embed token to view the specified dashboard from the specified workspace.
create_dataflow_refreshChanges dataCreate a new refresh for a dataflow. Required: notify option. API summary: Triggers a refresh for the specified dataflow.
create_datasetChanges dataCreate a new dataset. Required: name or tables. API summary: Creates a new dataset on My workspace.
create_dataset_default_bind_to_gatewayChanges dataCreate a new default bind to gateway for a dataset. Required: gateway object id. API summary: Binds the specified dataset from My workspace to the specified gateway, optionally with a given set of data source IDs.
create_dataset_default_bind_to_gateway_datasets_bind_to_gateway_Changes dataCreate a new default bind to gateway for a dataset. Required: gateway object id. API summary: Binds the specified dataset from the specified workspace to the specified gateway, optionally with a given set of data source IDs.
create_dataset_default_take_overChanges dataCreate a new default take over for a dataset. API summary: Transfers ownership over the specified dataset to the current authorized user.
create_dataset_default_update_datasourceChanges dataCreate a new default update datasource for a dataset. Required: update details. API summary: Updates the data sources of the specified dataset from My workspace.
create_dataset_default_update_datasource_datasets_update_datasouChanges dataCreate a new default update datasource for a dataset. Required: update details. API summary: Updates the data sources of the specified dataset from the specified workspace.
create_dataset_default_update_parameterChanges dataCreate a new default update parameter for a dataset. Required: update details. API summary: Updates the parameters values for the specified dataset from My workspace.
create_dataset_default_update_parameter_datasets_update_parameteChanges dataCreate a new default update parameter for a dataset. Required: update details. API summary: Updates the parameters values for the specified dataset from the specified workspace.
create_dataset_generate_tokenDeletesCreate a new generate token for a dataset. Destructive action; may require approval. API summary: Generates an embed token based on the specified dataset from the specified workspace.
create_dataset_userChanges dataCreate a new user for a dataset. Required: dataset user access right, identifier or principal type. API summary: Grants the specified user's permissions to the specified dataset.
create_dataset_user_datasets_post_dataset_userChanges dataCreate a new user for a dataset. Required: dataset user access right, identifier or principal type. API summary: Grants the specified user's permissions to the specified dataset.
create_datasource_userChanges dataCreate a new user for a datasource. Required: datasource access right. API summary: Grants or updates the permissions required to use the specified data source for the specified user.
create_gateway_datasourceChanges dataCreate a new datasource for a gateway. Required: data source type, connection details, credential details or data source name. API summary: Creates a new data source on the specified on-premises gateway.
create_generate_tokenDeletesCreate a new generate token. Destructive action; may require approval. API summary: Generates an embed token to allow report creation in the specified workspace based on the specified dataset.
create_generate_token_embed_token_generate_tokenDeletesCreate a new generate token. Destructive action; may require approval. API summary: Generates an embed token for multiple reports, datasets, and target workspaces.
create_goalChanges dataCreate a new goal. Required: name. API summary: Adds a new goal to a scorecard.
create_goal_valueChanges dataCreate a new goal value. Required: timestamp. API summary: Creates a new goal value check-in.
create_groupChanges dataCreate a new group. Required: name. API summary: Creates a new workspace.
create_group_dashboardChanges dataCreate a new dashboard for a group. Required: name. API summary: Creates a new empty dashboard in the specified workspace.
create_group_datasetChanges dataCreate a new dataset for a group. Required: name or tables. API summary: Creates a new dataset in the specified workspace.
create_group_importChanges dataCreate a new import for a group. Required: dataset display name. API summary: Creates new content in the specified workspace.
create_group_scorecardChanges dataCreate a new scorecard for a group. Required: name. API summary: Creates a new scorecard.
create_group_userChanges dataCreate a new user for a group. Required: group user access right, identifier or principal type. API summary: Grants the specified user the specified permissions to the specified workspace.
create_importChanges dataCreate a new import. Required: dataset display name. API summary: Creates new content in My workspace.
create_import_temporary_upload_locationChanges dataCreate a new import. API summary: Creates a temporary blob storage upload location for importing large Power BI .pbix files that are between 1 GB and 10 GB in size.
create_import_temporary_upload_location_createChanges dataCreate a new import. API summary: Creates a temporary blob storage upload location for importing large Power BI .pbix files that are between 1 GB and 10 GB in size.
create_messageChanges dataCreate a new message. Required: body. API summary: Adds a new note to a goal value check-in.
create_move_goalChanges dataCreate a new move goal. Required: goal to move. API summary: Moves goals within the scorecard. Changes their ranks and parents.
create_pipelineChanges dataCreate a new pipeline. Required: display name. API summary: Creates a new deployment pipeline.
create_pipeline_deployChanges dataCreate a new deploy for a pipeline. Required: source stage order. API summary: Deploys the specified items from the source stage of the specified deployment pipeline.
create_pipeline_deploy_allChanges dataCreate a new deploy all for a pipeline. Required: source stage order. API summary: Deploys all supported items from the source stage of the specified deployment pipeline.
create_pipeline_userChanges dataCreate a new user for a pipeline. Required: identifier or principal type. API summary: Grants user permissions to the specified deployment pipeline.
create_profileChanges dataCreate a new profile. API summary: Creates a new service principal profile.
create_report_default_bind_to_gatewayChanges dataCreate a new default bind to gateway for a report. Required: gateway object id or bind details. API summary: Binds the specified data source of the paginated report from My workspace to the specified gateway, optionally with a given data source ID.
create_report_default_bind_to_gateway_reports_bind_to_gateway_inChanges dataCreate a new default bind to gateway for a report. Required: gateway object id or bind details. API summary: Binds the specified data source of the paginated report from the specified workspace to the specified gateway, optionally with a given data….
create_report_default_take_overChanges dataCreate a new default take over for a report. API summary: Transfers ownership of the data sources for the specified paginated report (RDL) to the current authorized user.
create_report_default_update_datasourceChanges dataCreate a new default update datasource for a report. Required: update details. API summary: Updates the data sources of the specified paginated report (RDL) from My workspace.
create_report_default_update_datasource_reports_update_datasourcChanges dataCreate a new default update datasource for a report. Required: update details. API summary: Updates the data sources of the specified paginated report (RDL) from the specified workspace.
create_report_generate_tokenDeletesCreate a new generate token for a report. Destructive action; may require approval. API summary: Generates an embed token to view or edit the specified report from the specified workspace.
create_report_rebindChanges dataCreate a new rebind for a report. Required: dataset id. API summary: Rebinds the specified report from My workspace to the specified dataset.
create_report_rebind_reports_rebind_report_in_groupChanges dataCreate a new rebind for a report. Required: dataset id. API summary: Rebinds the specified report from the specified workspace to the specified dataset.
create_table_rowChanges dataCreate a new row for a table. API summary: Adds new data rows to the specified table within the specified dataset from My workspace.
create_ticket_template_app_install_ticketChanges dataCreate a new ticket. API summary: Generates an installation ticket for the automated install flow of the specified template app.
create_tile_generate_tokenDeletesCreate a new generate token for a tile. Destructive action; may require approval. API summary: Generates an embed token to view the specified tile from the specified workspace.
delete_dashboardDeletesPermanently delete a dashboard by dashboard id. Destructive action; may require approval. API summary: Deletes the specified dashboard from My workspace.
delete_datasetDeletesPermanently delete a dataset by dataset id. Destructive action; may require approval. API summary: Deletes the specified dataset from My workspace.
delete_dataset_refreshDeletesPermanently delete a refresh by refresh id. Destructive action; may require approval. API summary: Cancels the specified refresh operation for the specified dataset from My workspace.
delete_dataset_refresh_datasets_cancel_refresh_in_groupDeletesPermanently delete a refresh by refresh id. Destructive action; may require approval. API summary: Cancels the specified refresh operation for the specified dataset from the specified workspace.
delete_datasource_userDeletesPermanently delete a user by email adress. Destructive action; may require approval. API summary: Removes the specified user from the specified data source.
delete_gateway_datasourceDeletesPermanently delete a datasource by datasource id. Destructive action; may require approval. API summary: Deletes the specified data source from the specified gateway.
delete_goal_valuesMoves moneyPermanently delete a goal value by timestamp. Financial or irreversible action; may require approval. API summary: Deletes a goal value check-in by a UTC day timestamp.
delete_goalsMoves moneyPermanently delete a goal by goal id. Financial or irreversible action; may require approval. API summary: Deletes a goal from a scorecard by goal ID.
delete_goals_current_value_connectionDeletesPermanently delete a goal by goal id. Destructive action; may require approval. API summary: Disconnects the current value of a goal.
delete_goals_target_value_connectionDeletesPermanently delete a goal by goal id. Destructive action; may require approval. API summary: Disconnects the target value of a goal.
delete_groupDeletesPermanently delete a group by group id. Destructive action; may require approval. API summary: Deletes the specified workspace.
delete_group_dashboardDeletesPermanently delete a dashboard by dashboard id. Destructive action; may require approval. API summary: Deletes the specified dashboard from the specified workspace.
delete_group_dataflowDeletesPermanently delete a dataflow by dataflow id. Destructive action; may require approval. API summary: Deletes a dataflow from Power BI data prep storage, including its definition file and model.
delete_group_datasetDeletesPermanently delete a dataset by dataset id. Destructive action; may require approval. API summary: Deletes the specified dataset from the specified workspace.
delete_group_reportDeletesPermanently delete a report by report id. Destructive action; may require approval. API summary: Deletes the specified report from the specified workspace.
delete_group_scorecardsMoves moneyPermanently delete a scorecard by scorecard id. Financial or irreversible action; may require approval. API summary: Deletes a scorecard by its ID.
delete_group_userDeletesPermanently delete a user by user. Destructive action; may require approval. API summary: Deletes the specified user permissions from the specified workspace.
delete_messagesMoves moneyPermanently delete a message by note id. Financial or irreversible action; may require approval. API summary: Deletes a goal value check-in note by ID.
delete_pipelineDeletesPermanently delete a pipeline by pipeline id. Destructive action; may require approval. API summary: Deletes the specified deployment pipeline.
delete_pipeline_userDeletesPermanently delete a user by user identifier. Destructive action; may require approval. API summary: Removes user permissions from the specified deployment pipeline.
delete_profileDeletesPermanently delete a profile by profile id. Destructive action; may require approval. API summary: Deletes the specified service principal profile.
delete_reportDeletesPermanently delete a report by report id. Destructive action; may require approval. API summary: Deletes the specified report from My workspace.
delete_table_rowsMoves moneyPermanently delete a row by table name. Financial or irreversible action; may require approval. API summary: Deletes all rows from the specified table within the specified dataset from My workspace.
delete_table_rows_datasets_delete_rows_in_groupMoves moneyPermanently delete a row by table name. Financial or irreversible action; may require approval. API summary: Deletes all rows from the specified table within the specified dataset from the specified workspace.
detach_stage_workspaceChanges dataUnassign a stage (stage order). API summary: Unassigns the workspace from the specified stage in the specified deployment pipeline.
export_reportsExport reports. API summary: Exports the specified report from My workspace to a Power BI .pbix or .rdl file.
export_reports_exportExport reports. API summary: Exports the specified report from the specified workspace to a Power BI .pbix or .rdl file.
export_reports_toChanges dataExport reports. API summary: Exports the specified report from My workspace to the requested file format.
export_reports_to_exportChanges dataExport reports. API summary: Exports the specified report from the specified workspace to the requested file format.
get_appGet one app by app id. API summary: Returns the specified installed app.
get_app_dashboardGet one dashboard for a app by dashboard id. API summary: Returns the specified dashboard from the specified app.
get_app_reportGet one report for a app by report id. API summary: Returns the specified report from the specified app.
get_capacity_refreshableGet one refreshable for a capacity by refreshable id. API summary: Returns the specified refreshable for the specified capacity that the user has access to.
get_capacity_workloadGet one workload for a capacity by workload name. API summary: Returns the current state of a workload. If the workload is enabled, the percentage of maximum memory that the workload can consume is also….
get_dashboardGet one dashboard by dashboard id. API summary: Returns the specified dashboard from My workspace.
get_dashboard_tileGet one tile for a dashboard by tile id. API summary: Returns the specified tile within the specified dashboard from My workspace.
get_dashboard_tile_apps_get_tileGet one tile for a dashboard by tile id. API summary: Returns the specified tile within the specified dashboard from the specified app.
get_dashboard_tile_dashboards_get_tile_in_groupGet one tile for a dashboard by tile id. API summary: Returns the specified tile within the specified dashboard from the specified workspace.
get_dataset_refreshGet one refresh for a dataset by refresh id. API summary: Returns execution details of a refresh operation for the specified dataset from My workspace.
get_dataset_refresh_datasets_get_refresh_execution_details_in_grGet one refresh for a dataset by refresh id. API summary: Returns execution details of a refresh operation for the specified dataset from the specified workspace.
get_dataset_scheduleGet one dataset by dataset id. API summary: Returns the refresh schedule for the specified dataset from My workspace.
get_dataset_schedule_refreshGet one dataset by dataset id. API summary: Returns the refresh schedule for the specified dataset from the specified workspace.
get_datasource_statusGet the current status of a datasource by datasource id. API summary: Checks the connectivity status of the specified data source from the specified gateway.
get_gatewayGet one gateway by gateway id. API summary: Returns the specified gateway.
get_gateway_datasourceGet one datasource for a gateway by datasource id. API summary: Returns the specified data source from the specified gateway.
get_goal_refresh_historyGet one goal by goal id. API summary: Reads refresh history of a connected goal.
get_goal_status_rulesGet the current status of a goal by goal id. API summary: Returns status rules of a goal.
get_goal_status_rules_goals_status_rules_preview_deleteMoves moneyGet the current status of a goal by goal id. Financial or irreversible action; may require approval. API summary: Removes status rule definitions from a goal.
get_goal_status_rules_statusChanges dataGet the current status of a goal by goal id. API summary: Creates or updates status rules of a goal.
get_groupGet one group by group id. API summary: Returns a specified workspace.
get_group_dashboardGet one dashboard for a group by dashboard id. API summary: Returns the specified dashboard from the specified workspace.
get_group_dataflowGet one dataflow for a group by dataflow id. API summary: Exports the specified dataflow definition to a JSON file.
get_group_importGet one import for a group by import id. API summary: Returns the specified import from the specified workspace.
get_importGet one import by import id. API summary: Returns the specified import from My workspace.
get_my_datasetGet one dataset from your My workspace by dataset_id, including refresh settings and owner.
get_my_reportGet one report from your My workspace by report_id, including its web URL and dataset.
get_pipelineGet one pipeline by pipeline id. API summary: Returns the specified deployment pipeline.
get_pipeline_operationGet one operation for a pipeline by operation id. API summary: Returns the details of the specified deploy operation performed on the specified deployment pipeline, including the deployment execution pla….
get_profileGet one profile by profile id. API summary: Returns the specified service principal profile.
get_query_scale_out_statusGet one query scale out by dataset id. API summary: Returns the query scale-out sync status for the specified dataset from My workspace.
get_query_scale_out_status_syncGet one query scale out by dataset id. API summary: Returns the query scale-out sync status for the specified dataset from the specified workspace.
get_report_exportGet one export for a report by export id. API summary: Returns the current status of the Export to File job for the specified report from My workspace.
get_report_export_reports_get_export_to_file_status_in_groupGet one export for a report by export id. API summary: Returns the current status of the Export to File In Group job for the specified report from the specified workspace.
get_report_pageGet one page for a report by page name. API summary: Returns the specified page within the specified report from My workspace.
get_report_page_reports_get_page_in_groupGet one page for a report by page name. API summary: Returns the specified page within the specified report from the specified workspace.
get_scorecard_by_report_id_report_idGet one scorecard by report id. API summary: Reads a scorecard associated with an internal report ID.
get_workspace_datasetGet one dataset in a workspace by group_id and dataset_id, including refresh settings and owner.
get_workspace_reportGet one report in a workspace by group_id and report_id, including its web URL and dataset.
list_accountsList accounts. API summary: Returns a list of dataflow storage accounts that the user has access to.
list_app_dashboardsList dashboards for a app. API summary: Returns a list of dashboards from the specified app.
list_app_reportsList reports for a app. API summary: Returns a list of reports from the specified app.
list_appsList apps. API summary: Returns a list of installed apps.
list_available_featuresList available features. API summary: Returns a list of available features for the user.
list_available_features_feature_namesList available features feature names. API summary: Returns the specified available feature for the user by name.
list_capacitiesList capacities. API summary: Returns a list of capacities that the user has access to.
list_capacity_assignment_statusesList capacity assignment statuses. API summary: Gets the status of the My workspace assignment-to-capacity operation.
list_capacity_refreshablesList refreshables for a capacity. Optional filters: expand or filter. Results are paginated. API summary: Returns a list of refreshables for the specified capacity that the user has access to.
list_capacity_workloadsList workloads for a capacity. API summary: Returns the current state of the specified capacity workloads. If a workload is enabled, the percentage of maximum memory that the workload….
list_dashboard_tilesList the tiles on a dashboard in a workspace by group_id and dashboard_id.
list_dashboard_tiles_2List tiles for a dashboard. API summary: Returns a list of tiles within the specified dashboard from My workspace.
list_dashboard_tiles_apps_get_tilesList tiles for a dashboard. API summary: Returns a list of tiles within the specified dashboard from the specified app.
list_dataflow_datasourcesList datasources for a dataflow. API summary: Returns a list of data sources for the specified dataflow.
list_dataflow_paymentsList payments for a dataflow. API summary: Returns a list of transactions for the specified dataflow.
list_dataflow_upstream_dataflowsList upstream dataflows for a dataflow. API summary: Returns a list of upstream dataflows for the specified dataflow.
list_dataset_datasourcesList datasources for a dataset. API summary: Returns a list of data sources for the specified dataset from My workspace.
list_dataset_datasources_datasets_get_datasources_in_groupList datasources for a dataset. API summary: Returns a list of data sources for the specified dataset from the specified workspace.
list_dataset_default_discover_gatewaysList default discover gateways for a dataset. API summary: Returns a list of gateways that the specified dataset from My workspace can be bound to.
list_dataset_default_discover_gateways_datasets_discover_gatewayList default discover gateways for a dataset. API summary: Returns a list of gateways that the specified dataset from the specified workspace can be bound to.
list_dataset_default_get_bound_gateway_datasourcesList default get bound gateway datasources for a dataset. API summary: Returns a list of gateway data sources for the specified dataset from My workspace.
list_dataset_default_get_bound_gateway_datasources_datasets_get_List default get bound gateway datasources for a dataset. API summary: Returns a list of gateway data sources for the specified dataset from the specified workspace.
list_dataset_parametersList parameters for a dataset. API summary: Returns a list of parameters for the specified dataset from My workspace.
list_dataset_parameters_datasets_get_parameters_in_groupList parameters for a dataset. API summary: Returns a list of parameters for the specified dataset from the specified workspace.
list_dataset_tablesList the tables of a push dataset in a workspace by group_id and dataset_id.
list_dataset_tables_2List tables for a dataset. API summary: Returns a list of tables within the specified dataset from My workspace.
list_dataset_usersList users for a dataset. API summary: Returns a list of principals that have access to the specified dataset.
list_dataset_users_datasets_get_dataset_usersList users for a dataset. API summary: Returns a list of principals that have access to the specified dataset.
list_datasource_usersList users for a datasource. API summary: Returns a list of users who have access to the specified data source.
list_export_documentsList documents for a export. API summary: Returns the file from the Export to File job for the specified report from My workspace.
list_export_documents_reports_get_file_of_export_to_file_in_grouList documents for a export. API summary: Returns the file from the Export to File In Group job for the specified report from the specified workspace.
list_gateway_datasourcesList datasources for a gateway. API summary: Returns a list of data sources from the specified gateway.
list_gatewaysList gateways. API summary: Returns a list of gateways for which the user is an admin.
list_goal_valuesList goal values. Optional filters: expand. API summary: Reads goal value check-ins.
list_goal_values_goal_values_preview_get_by_idList goal values. Optional filters: expand. API summary: Reads a goal value check-in by a UTC date timestamp.
list_goalsList goals. Optional filters: expand or select. API summary: Returns a list of goals from a scorecard.
list_goals_goals_preview_get_by_idList goals. API summary: Returns a goal by ID from a scorecard.
list_group_capacity_assignment_statusesList capacity assignment statuses for a group. API summary: Gets the status of the assignment-to-capacity operation for the specified workspace.
list_group_dataflowsList dataflows for a group. API summary: Returns a list of all dataflows from the specified workspace.
list_group_importsList imports for a group. API summary: Returns a list of imports from the specified workspace.
list_group_scorecardsList scorecards for a group. Results are paginated. API summary: Returns a list of scorecards from a workspace.
list_group_scorecards_scorecards_preview_get_by_idList scorecards for a group. Optional filters: expand. API summary: Returns a scorecard with ID.
list_group_usersList users for a group. Results are paginated. API summary: Returns a list of users that have access to the specified workspace.
list_importsList imports. API summary: Returns a list of imports from My workspace.
list_my_dashboardsList the dashboards in your personal My workspace.
list_my_dataset_refreshesList the refresh history of a dataset in your My workspace by dataset_id, with an optional limit. Use to check whether a refresh succeeded.
list_my_datasetsList the datasets (semantic models) in your personal My workspace.
list_my_reportsList the reports in your personal My workspace.
list_pipeline_operationsList operations for a pipeline. API summary: Returns a list of the up-to-20 most recent deploy operations performed on the specified deployment pipeline.
list_pipeline_stagesList stages for a pipeline. API summary: Returns the stages of the specified deployment pipeline.
list_pipeline_usersList users for a pipeline. API summary: Returns a list of users that have access to the specified deployment pipeline.
list_pipelinesList pipelines. API summary: Returns a list of deployment pipelines that the user has access to.
list_profilesList profiles. Optional filters: filter. Results are paginated. API summary: Returns a list of service principal profiles.
list_refreshablesList refreshables. Optional filters: expand or filter. Results are paginated. API summary: Returns a list of refreshables for all capacities that the user has access to.
list_report_datasourcesList datasources for a report. API summary: Returns a list of data sources for the specified paginated report (RDL) from My workspace.
list_report_datasources_reports_get_datasources_in_groupList datasources for a report. API summary: Returns a list of data sources for the specified paginated report (RDL) from the specified workspace.
list_report_pagesList the pages of a report in a workspace by group_id and report_id.
list_report_pages_2List pages for a report. API summary: Returns a list of pages within the specified report from My workspace.
list_stage_artifactsList artifacts for a stage. API summary: Returns the supported items from the workspace assigned to the specified stage of the specified deployment pipeline.
list_upstream_dataflowsList upstream dataflows. API summary: Returns a list of upstream dataflows for datasets from the specified workspace.
list_workspace_dashboardsList the dashboards in a workspace by group_id.
list_workspace_dataset_refreshesList the refresh history of a dataset in a workspace by group_id and dataset_id, with an optional limit. Use to check whether a refresh succeeded.
list_workspace_datasetsList the datasets (semantic models) in a workspace by group_id.
list_workspace_reportsList the reports in a workspace by group_id.
list_workspacesList the Power BI workspaces you can access, with optional OData filter, limit and offset. Use to find a workspace's group_id.
refresh_my_datasetChanges dataStart a data refresh of a dataset in your My workspace by dataset_id. notify_option is required: NoNotification, MailOnFailure or MailOnCompletion.
refresh_workspace_datasetChanges dataStart a data refresh of a dataset in a workspace by group_id and dataset_id. notify_option is required: NoNotification, MailOnFailure or MailOnCompletion.
run_query_my_datasetChanges dataRun a DAX query against a dataset in your My workspace. Pass dataset_id and queries as a list with one item like {"query": "EVALUATE ..."}. Read-only.
run_query_workspace_datasetChanges dataRun a DAX query against a dataset in a workspace. Pass group_id, dataset_id and queries as a list with one item like {"query": "EVALUATE ..."}. Read-only.
search_dataset_direct_query_refresh_schedulesSearch direct query refresh schedules for a dataset. Use this to find existing direct query refresh schedules before creating a new direct query refresh schedule. API summary: Returns the refresh schedule for a specified DirectQuery or LiveConnection dataset from My workspace.
search_dataset_direct_query_refresh_schedules_datasets_get_direcSearch direct query refresh schedules for a dataset. Use this to find existing direct query refresh schedules before creating a new direct query refresh schedule. API summary: Returns the refresh schedule for a specified DirectQuery or LiveConnection dataset from the specified workspace.
submit_dataflow_scheduleVisible to othersRefresh a dataflow (dataflow id). Has effects visible outside this system. API summary: Creates or updates the refresh schedule for a specified dataflow.
submit_dataset_scheduleVisible to othersRefresh a dataset (dataset id). Has effects visible outside this system. API summary: Updates the refresh schedule for the specified dataset from My workspace.
submit_dataset_schedule_refreshVisible to othersRefresh a dataset (dataset id). Has effects visible outside this system. API summary: Updates the refresh schedule for the specified dataset from the specified workspace.
submit_goal_current_valueVisible to othersRefresh a goal (goal id). Has effects visible outside this system. API summary: Schedules a refresh of the connected value of a goal.
submit_goal_target_valueVisible to othersRefresh a goal (goal id). Has effects visible outside this system. API summary: Schedules a refresh of the target value of a goal.
submit_query_scale_outVisible to othersSync a query scale out (dataset id). Has effects visible outside this system. API summary: Triggers a query scale-out sync of read-only replicas for the specified dataset from My workspace.
submit_query_scale_out_syncVisible to othersSync a query scale out (dataset id). Has effects visible outside this system. API summary: Triggers a query scale-out sync of read-only replicas for the specified dataset from the specified workspace.
submit_reportVisible to othersClone a report (report id). Has effects visible outside this system. API summary: Clones the specified report from My workspace.
submit_report_cloneVisible to othersClone a report (report id). Has effects visible outside this system. API summary: Clones the specified report from the specified workspace.
submit_ticket_user_permissionsDeletesRefresh a ticket. Destructive action; may require approval. API summary: Refreshes user permissions in Power BI.
submit_tileVisible to othersClone a tile (tile id). Has effects visible outside this system. API summary: Clones the specified tile from My workspace.
submit_tile_cloneVisible to othersClone a tile (tile id). Has effects visible outside this system. API summary: Clones the specified tile from the specified workspace.
update_capacity_workloadChanges dataUpdate an existing workload identified by workload name. Only the fields you pass are changed. API summary: Changes the state of a specific workload to Enabled or Disabled. When enabling a workload, specify the percentage of maximum memory that the….
update_dataflow_as_native_artifactChanges dataUpdate an existing dataflow identified by gen1 dataflow id. API summary: Save Dataflow Gen1 As Dataflow Gen2 (CI/CD) (Preview).
update_datasetChanges dataUpdate an existing dataset identified by dataset id. Only the fields you pass are changed. API summary: Updates the properties for the specified dataset from My workspace.
update_dataset_direct_query_refresh_schedulesVisible to othersUpdate an existing direct query refresh schedule identified by dataset id. Only the fields you pass are changed. Has effects visible outside this system. API summary: Updates the refresh schedule for a specified DirectQuery or LiveConnection dataset from My workspace.
update_dataset_tableChanges dataUpdate an existing table identified by table name. API summary: Updates the metadata and schema for the specified table within the specified dataset from My workspace.
update_dataset_usersVisible to othersUpdate an existing user identified by dataset id. Has effects visible outside this system. API summary: Updates the existing dataset permissions of the specified user to the specified permissions.
update_gateway_datasourceChanges dataUpdate an existing datasource identified by datasource id. Only the fields you pass are changed. API summary: Updates the credentials of the specified data source from the specified gateway.
update_goal_valuesVisible to othersUpdate an existing goal value identified by timestamp. Only the fields you pass are changed. Has effects visible outside this system. API summary: Updates a goal value check-in by a UTC date timestamp.
update_goalsVisible to othersUpdate an existing goal identified by goal id. Only the fields you pass are changed. Has effects visible outside this system. API summary: Updates a goal by ID.
update_groupChanges dataUpdate an existing group identified by group id. Only the fields you pass are changed. API summary: Updates a specified workspace.
update_group_dataflowChanges dataUpdate an existing dataflow identified by dataflow id. Only the fields you pass are changed. API summary: Updates dataflow properties, capabilities and settings.
update_group_datasetChanges dataUpdate an existing dataset identified by dataset id. Only the fields you pass are changed. API summary: Updates the properties for the specified dataset from the specified workspace.
update_group_scorecardsVisible to othersUpdate an existing scorecard identified by scorecard id. Only the fields you pass are changed. Has effects visible outside this system. API summary: Updates a scorecard by its ID.
update_group_usersVisible to othersUpdate an existing user identified by group id. Has effects visible outside this system. API summary: Updates the specified user permissions to the specified workspace.
update_messagesVisible to othersUpdate an existing message identified by note id. Only the fields you pass are changed. Has effects visible outside this system. API summary: Updates a goal value check-in note by ID.
update_pipelineChanges dataUpdate an existing pipeline identified by pipeline id. Only the fields you pass are changed. API summary: Updates the specified deployment pipeline.
update_profileChanges dataUpdate an existing profile identified by profile id. API summary: Updates the specified service principal profile name.
update_report_contentChanges dataUpdate an existing report identified by report id. API summary: Updates the content of the specified report from My workspace with the content of a specified source report.
update_report_content_updateChanges dataUpdate an existing report identified by report id. API summary: Updates the content of the specified report from the specified workspace with the content of a specified source report.

Set up in three steps

1
Pick the app
Create a free HeyMyApps account and choose Microsoft Power BI from the app list.
2
Paste your key
Create your own Microsoft Entra app, paste its Application (client) ID and client secret value, then sign in with Microsoft once. In the Azure portal open Microsoft Entra ID > App registrations > New registration, choose 'Accounts in any organizational directory' and add the Web redirect URI https://heymyapps.com/oauth/callback. Create a client secret under Certificates & secrets, and under API permissions add the Power BI Service delegated permissions Workspace.Read.All, Dataset.ReadWrite.All, Report.Read.All and Dashboard.Read.All.
3
Add the link to your AI
You get a personal MCP link. Add it to Claude, ChatGPT or Cursor:
1. Click your name, then Settings › Connectors › Add custom connector.
2. Paste your link as the Remote MCP server URL.
3. Switch it on from the + menu in a chat.

Questions

What can the AI do in Power BI?

It can list workspaces, datasets, reports, report pages, dashboards and dashboard tiles, both in shared workspaces and in your My workspace. It can read datasets and reports, run read-only DAX queries, read refresh history, start a data refresh and add rows to a push dataset.

Does the AI see my Power BI credentials?

No. Your client ID, client secret and sign-in tokens are encrypted at rest and never shown to the AI. After you save them, they are not shown again, not even to you. The AI only sees the results of the tools it calls.

Can I control what the AI is allowed to do?

Yes. You choose which tools are switched on, so you can start with lookups and DAX queries only. Starting a refresh and adding rows to a push dataset change data in Power BI, and both can require your approval before they run. Every tool call is logged.

Does it work with ChatGPT?

Yes. In ChatGPT, open Settings › Apps & Connectors › Advanced, turn on Developer mode and add your HeyMyApps link. Developer mode needs a paid ChatGPT plan: Plus, Pro, Business or Enterprise. The same link also works in Claude (Settings › Connectors › Add custom connector), Cursor and other MCP clients.

What does it cost?

Power BI connects with OAuth, and OAuth connections need the HeyMyApps Pro plan or above. HeyMyApps also has a free plan with no credit card, but it does not include this connection. Paid plans bill per completed task. You also need your own Power BI account.

Can the AI read the numbers in my datasets?

Yes. It writes a DAX query and runs it against the dataset, in a shared workspace or in your My workspace. The query only reads data and changes nothing. You can ask in plain words, for example revenue per month, and the AI builds the query for you.