fabric-data-agent-remediate

Name: fabric-data-agent-remediate
Author: PatrickGallucci

16stars1forks

How to install fabric-data-agent-remediate?

patrickgallucci/fabric-skills/fabric-data-agent-remediate

$npx -y skills add PatrickGallucci/fabric-skills --skill fabric-data-agent-remediate

Installs into the current project.

Summary

Diagnose and resolve Microsoft Fabric Data Agent issues including tenant settings, data source configuration, query generation failures, cross-region capacity errors, XMLA endpoint setup, Power BI semantic model integration, lakehouse/warehouse/KQL connectivity, example query val

Files · 1

View on GitHub

SKILL.md

1	# Fabric Data Agent remediate
2
3	Structured remediate guide for diagnosing and resolving issues with Microsoft Fabric Data Agent (preview). Covers the full lifecycle from tenant configuration through data source setup, query tuning, publishing, and external integration.
4
5	## When to Use This Skill
6
7	- Fabric data agent cannot be created or is missing from the workspace
8	- Data agent returns errors, empty results, or inaccurate queries
9	- Tenant settings are misconfigured for Copilot and Azure OpenAI
10	- Power BI semantic model data source fails to connect (XMLA)
11	- Cross-region capacity errors prevent query execution
12	- Example queries fail validation or are ignored by the agent
13	- Published data agent is inaccessible to shared users
14	- Azure AI Foundry or Copilot Studio integration issues
15	- Agent generates incorrect SQL, DAX, or KQL queries
16	- Conversation history is lost or not persisting
17
18	## Prerequisites
19
20	- Microsoft Fabric capacity: F2 or higher (or Power BI Premium P1+ with Fabric enabled)
21	- Fabric Admin Portal access (for tenant settings)
22	- At least one data source with data: lakehouse, warehouse, Power BI semantic model, KQL database, or ontology
23	- Workspace Contributor (or higher) permissions
24	- PowerShell 7+ recommended for diagnostic scripts
25
26	## Quick Diagnosis Workflow
27
28	Follow this decision tree to rapidly identify your issue category:
29
30	1. Cannot create data agent? → See [Tenant Settings Checklist](./references/tenant-settings-checklist.md)
31	2. Data agent created but queries fail? → See [Query remediate](./references/query-remediate.md)
32	3. Data source not appearing or erroring? → See [Data Source Connectivity](./references/data-source-connectivity.md)
33	4. Published agent inaccessible? → See [Publishing and Sharing](./references/publishing-and-sharing.md)
34	5. Integration with Foundry/Teams failing? → See [External Integration](./references/external-integration.md)
35
36	## Known Limitations (Preview)
37
38	These are product limitations, not configuration errors. Do not troubleshoot these as bugs:
39
40	\| Limitation \| Detail \|
41	\| ----------------------- \| ---------------------------------------------------------------------- \|
42	\| Read-only queries \| Agent generates only SELECT/read queries; no INSERT, UPDATE, or DELETE \|
43	\| English only \| Non-English questions, instructions, and examples are not supported \|
44	\| No unstructured data \| PDF, DOCX, TXT files cannot be used as data sources \|
45	\| Lakehouse files \| Agent reads lakehouse tables only, not standalone CSV/JSON files \|
46	\| Fixed LLM \| The underlying LLM model cannot be changed \|
47	\| Max 5 data sources \| Up to five data sources in any combination per agent \|
48	\| Max 100 example queries \| Per data source limit for example query pairs \|
49	\| Cross-region blocked \| Data source and agent capacities must be in the same region \|
50	\| Conversation history \| May reset during backend updates or model upgrades \|
51	\| No PBI example queries \| Power BI semantic models do not support sample query/question pairs \|
52
53	## Common Error Patterns
54
55	\| Symptom \| Likely Cause \| Quick Fix \|
56	\| --------------------------------- \| ------------------------------------------- \| ------------------------------------------------------------------------- \|
57	\| "Data agent" item type missing \| Tenant setting disabled \| Enable "Fabric data agent" in Admin Portal \|
58	\| Agent created but no response \| Copilot tenant switch off \| Enable "Users can use Copilot and other features powered by Azure OpenAI" \|
59	\| Cross-geo processing error \| Cross-geo settings disabled \| Enable both cross-geo processing AND storing settings \|
60	\| XMLA connection failure \| XMLA endpoints not enabled \| Enable "Allow XMLA endpoints" in Integration settings \|
61	\| Query returns empty/wrong results \| Poor table/column names or missing examples \| Add descriptive names and example query pairs

People who liked this also viewed

6 picks

Type

fabric-data-agent-remediate

16stars1forks

View on GitHub

How to install fabric-data-agent-remediate?

patrickgallucci/fabric-skills/fabric-data-agent-remediate

$npx -y skills add PatrickGallucci/fabric-skills --skill fabric-data-agent-remediate

Installs into the current project.

Summary

Files · 1

View on GitHub

SKILL.md

1	# Fabric Data Agent remediate
2
3	Structured remediate guide for diagnosing and resolving issues with Microsoft Fabric Data Agent (preview). Covers the full lifecycle from tenant configuration through data source setup, query tuning, publishing, and external integration.
4
5	## When to Use This Skill
6
7	- Fabric data agent cannot be created or is missing from the workspace
8	- Data agent returns errors, empty results, or inaccurate queries
9	- Tenant settings are misconfigured for Copilot and Azure OpenAI
10	- Power BI semantic model data source fails to connect (XMLA)
11	- Cross-region capacity errors prevent query execution
12	- Example queries fail validation or are ignored by the agent
13	- Published data agent is inaccessible to shared users
14	- Azure AI Foundry or Copilot Studio integration issues
15	- Agent generates incorrect SQL, DAX, or KQL queries
16	- Conversation history is lost or not persisting
17
18	## Prerequisites
19
20	- Microsoft Fabric capacity: F2 or higher (or Power BI Premium P1+ with Fabric enabled)
21	- Fabric Admin Portal access (for tenant settings)
22	- At least one data source with data: lakehouse, warehouse, Power BI semantic model, KQL database, or ontology
23	- Workspace Contributor (or higher) permissions
24	- PowerShell 7+ recommended for diagnostic scripts
25
26	## Quick Diagnosis Workflow
27
28	Follow this decision tree to rapidly identify your issue category:
29
30	1. Cannot create data agent? → See [Tenant Settings Checklist](./references/tenant-settings-checklist.md)
31	2. Data agent created but queries fail? → See [Query remediate](./references/query-remediate.md)
32	3. Data source not appearing or erroring? → See [Data Source Connectivity](./references/data-source-connectivity.md)
33	4. Published agent inaccessible? → See [Publishing and Sharing](./references/publishing-and-sharing.md)
34	5. Integration with Foundry/Teams failing? → See [External Integration](./references/external-integration.md)
35
36	## Known Limitations (Preview)
37
38	These are product limitations, not configuration errors. Do not troubleshoot these as bugs:
39
40	\| Limitation \| Detail \|
41	\| ----------------------- \| ---------------------------------------------------------------------- \|
42	\| Read-only queries \| Agent generates only SELECT/read queries; no INSERT, UPDATE, or DELETE \|
43	\| English only \| Non-English questions, instructions, and examples are not supported \|
44	\| No unstructured data \| PDF, DOCX, TXT files cannot be used as data sources \|
45	\| Lakehouse files \| Agent reads lakehouse tables only, not standalone CSV/JSON files \|
46	\| Fixed LLM \| The underlying LLM model cannot be changed \|
47	\| Max 5 data sources \| Up to five data sources in any combination per agent \|
48	\| Max 100 example queries \| Per data source limit for example query pairs \|
49	\| Cross-region blocked \| Data source and agent capacities must be in the same region \|
50	\| Conversation history \| May reset during backend updates or model upgrades \|
51	\| No PBI example queries \| Power BI semantic models do not support sample query/question pairs \|
52
53	## Common Error Patterns
54
55	\| Symptom \| Likely Cause \| Quick Fix \|
56	\| --------------------------------- \| ------------------------------------------- \| ------------------------------------------------------------------------- \|
57	\| "Data agent" item type missing \| Tenant setting disabled \| Enable "Fabric data agent" in Admin Portal \|
58	\| Agent created but no response \| Copilot tenant switch off \| Enable "Users can use Copilot and other features powered by Azure OpenAI" \|
59	\| Cross-geo processing error \| Cross-geo settings disabled \| Enable both cross-geo processing AND storing settings \|
60	\| XMLA connection failure \| XMLA endpoints not enabled \| Enable "Allow XMLA endpoints" in Integration settings \|
61	\| Query returns empty/wrong results \| Poor table/column names or missing examples \| Add descriptive names and example query pairs

People who liked this also viewed

6 picks

Type