# Powerbi AI Native Source Router

> Use when each source table or query must be routed to the correct native Power Query connector pattern, including Excel, CSV, Folder, SharePoint, SQL, Fabric, OData, REST, SaaS, ODBC/OLE DB, or embedded demo mode.

- Skill: `rweisssieker-xp/powerbi-ai-native-source-router` (Agent Skill)
- Install (CLI): `npx skillmds@latest add rweisssieker-xp/powerbi-ai-native-source-router`
- Raw SKILL.md: https://api.skillmd.com/api/skills/rweisssieker-xp/powerbi-ai-native-source-router/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: rweisssieker-xp (https://skillmd.com/u/rweisssieker-xp)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/rweisssieker-xp/powerbi-ai-native-source-router

---


# Power BI AI Native Source Router

Use this skill when source access must be generated or reviewed.

## Routing Rules

- Prefer first-party/native Power Query connectors for production.
- Use `Excel.Workbook` for Excel workbook sheets and tables.
- Use `Csv.Document` for CSV files.
- Use `Folder.Files` or `SharePoint.Files` for file collections.
- Use database connectors for SQL/Fabric/Snowflake/Databricks and similar systems.
- Use `OData.Feed` or `Web.Contents` only when native service connectors are not suitable.
- Use embedded `DATATABLE` only for offline demos and smoke-test fixtures.

## Output Requirements

- For every table: source family, connector function, path/endpoint pattern, auth, gateway, privacy, refresh mode, folding expectation, and fallback.
- Flag missing source objects before generating M.

## Executable Support

- Use `data/powerbi_connector_matrix.json` as the local connector decision source.
- Use `scripts/powerbi_expert_factory.py validate --project <pbip-folder>` to detect native connector functions, `DATATABLE` demo usage, missing file references, and brittle numeric M navigation.