**Title: ** [Feature Request]
**Description: **
Request to extend the Power BI MCP server to support programmatic creation and configuration of visuals/reports. Currently, the MCP server provides excellent support for data model operations (tables, measures, relationships, DAX queries) but requires manual visual creation in Power BI Desktop.
**Use Case: **
Current workflow requires switching between MCP and Power BI Desktop GUI:
- Use MCP to create data model (tables, measures) ✅
- Manually create visuals in Power BI Desktop ❌
- Manually configure fields, formatting, filters ❌
- Return to MCP for model updates ✅
- Manually fix broken visual bindings after model changes ❌
With visual creation support, developers could:
- Build complete dashboards programmatically via natural language
- Version control entire reports (not just data models)
- Automate dashboard deployments in CI/CD pipelines
- Apply standardized templates and formatting
- Reproduce dashboards from code
**Example Use Case: **
Built a delay analysis dashboard using MCP for the data model (calculated tables, 9 DAX measures, relationships). All data model work was efficient via MCP, but had to manually create 5 visuals (table, cards, bar chart, matrix, slicer) and configure their properties in the GUI. When we updated a column name, visual field bindings broke and required manual reconfiguration.
**Proposed Operations: **
mcp_powerbi-visual_operations:
- CreateVisual (table, matrix, card, chart, slicer)
- UpdateVisual
- DeleteVisual
- GetVisual
- ListVisuals
mcp_powerbi-page_operations:
- CreatePage
- UpdatePage
- GetPage
mcp_powerbi-interaction_operations:
- SetCrossFilter
- SetVisualInteractions
Example API Call:
{
"operation": "CreateVisual",
"pageName": "Dashboard",
"visualType": "table",
"fields": {
"columns": ["TableName[ColumnName]"],
"values": ["[MeasureName]"]
},
"position": {"x": 0, "y": 0, "width": 400, "height": 300},
"formatting": {
"conditionalFormatting": {
"field": "[MeasureName]",
"rules": [{"min": 0, "max": 100, "color": "#FF0000"}]
}
}
}
**Title: ** [Feature Request]
**Description: **
Request to extend the Power BI MCP server to support programmatic creation and configuration of visuals/reports. Currently, the MCP server provides excellent support for data model operations (tables, measures, relationships, DAX queries) but requires manual visual creation in Power BI Desktop.
**Use Case: **
Current workflow requires switching between MCP and Power BI Desktop GUI:
With visual creation support, developers could:
**Example Use Case: **
Built a delay analysis dashboard using MCP for the data model (calculated tables, 9 DAX measures, relationships). All data model work was efficient via MCP, but had to manually create 5 visuals (table, cards, bar chart, matrix, slicer) and configure their properties in the GUI. When we updated a column name, visual field bindings broke and required manual reconfiguration.
**Proposed Operations: **
Example API Call:
{ "operation": "CreateVisual", "pageName": "Dashboard", "visualType": "table", "fields": { "columns": ["TableName[ColumnName]"], "values": ["[MeasureName]"] }, "position": {"x": 0, "y": 0, "width": 400, "height": 300}, "formatting": { "conditionalFormatting": { "field": "[MeasureName]", "rules": [{"min": 0, "max": 100, "color": "#FF0000"}] } } }