Does Power BI Copilot need more than a Pro license?

Yes. Copilot also needs paid Fabric F2 or Premium P1 capacity. F2 starts around $260 per month.

How much does Power BI Copilot actually cost?

Copilot is metered through paid Fabric or Premium capacity. Pro costs $14 per user monthly; Premium Per User costs $24.

Can Power BI Copilot query Snowflake or BigQuery directly?

Not directly. Fabric data agents use data in OneLake, with up to five sources per agent. Other warehouse data must be mirrored first.

All comparisons

Dot vs Power BI Copilot

Dot is stronger across Slack, multiple sources, and a second warehouse. Power BI Copilot makes sense when the data already lives in Fabric.

What are the differences between Dot and Power BI Copilot?

Showing 26 of 43 capabilities across 9 categories

02 / 10

Where can users receive answers?

Native Slack app

Dot: Yes. Native Slack app for business users
Power BI Copilot: No. No Slack app; chat surface is Teams Source

Native Microsoft Teams app

Dot: Yes. Native Teams app, not a pinned tab
Power BI Copilot: Partly. Pins into Teams; AI chat needs M365 license Source

Reachable over MCP from other assistants

Dot: Yes. MCP server reaches Claude, ChatGPT, MS Copilot
Power BI Copilot: Partly. No documented MCP server; uses Copilot Studio Source

Native mobile apps

Dot: No. Works in mobile browser; no native app
Power BI Copilot: Yes. Native iOS and Android apps Source

03 / 10

Which data sources can it access?

Warehouse and database connectors

Dot: Yes. 31 live connectors: Snowflake, BigQuery, Databricks, Redshift
Power BI Copilot: Partly. Over 100 connectors; Copilot analyzes OneLake data Source

Joins data across separate sources

Dot: Yes. Analysis across multiple warehouses
Power BI Copilot: Partly. Up to 5 sources, all Fabric-native Source

04 / 10

Which business context grounds its answers?

Grounded in dbt models and metrics

Dot: Yes. Uses dbt models and metrics as context
Power BI Copilot: No. Runs dbt jobs; Copilot doesn't read dbt metrics Source

Grounded in LookML

Dot: Yes. Uses Looker and LookML definitions as context
Power BI Copilot: No. No LookML support; uses its own semantic model Source

Your own metric and term definitions

Dot: Yes. Org-wide metrics and business-terms glossary, taught once
Power BI Copilot: Partly. Per-model instructions/synonyms, hand-authored, still in preview Source

05 / 10

How do you know the data is correct?

Shows the SQL behind every number

Dot: Yes. Click any number to see the SQL
Power BI Copilot: Partly. "How Copilot arrived" panel shows fields and DAX Source

Regression tests for important questions

Dot: Yes. Per-org eval question suites plus feedback-driven improvement
Power BI Copilot: Partly. Git-based ALM for agents; no eval suite Source

06 / 10

Who owns and maintains the business logic?

Business context lives in a repository you own

Dot: Yes. Two-way sync with your GitHub or GitLab
Power BI Copilot: Partly. Models support Git; verified answers do not Source

Context and apps use Git and pull requests

Dot: Yes. Every publish is versioned through Git and PRs
Power BI Copilot: Partly. Semantic models are reviewable and Git-ready Source

Context stays current when schemas change

Dot: Yes. Schema changes trigger assisted context review
Power BI Copilot: Partly. Agent audits models; authors approve updates Source

Context remains portable if you leave

Dot: Yes. Readable context and apps stay in your repository
Power BI Copilot: Partly. Human-readable TMDL exports, but Power BI-specific Source

07 / 10

Which outputs can it produce?

Multi-step investigations, not just lookups

Dot: Yes. Multi-step investigation with parallel sub-agents, shows its plan
Power BI Copilot: No. Can't do anomaly detection, forecasting, or key-influencer analysis Source

Runs Python for statistical work

Dot: Yes. Uses Python for analysis beyond DAX
Power BI Copilot: Partly. DAX in chat; Python is a separate tool Source

White labeling and embedded analytics

Dot: Partly. Dashboard embedding; limited white-label controls
Power BI Copilot: Yes. Embedded analytics for customer-facing applications Source

Notebook or IDE for analysts

Dot: No. Runs Python internally; no analyst notebook workspace
Power BI Copilot: Yes. Fabric notebooks: Python, PySpark, SQL, Scala for analysts Source

08 / 10

Which governance and security controls are included?

Self-hosting available

Dot: Partly. Self-hosting only on Enterprise tier
Power BI Copilot: No. SaaS-only; on-prem Report Server has no AI Source

Uses the platform's native governance

Dot: No. Separate service; metadata and samples sync to Dot
Power BI Copilot: Yes. Runs inside Fabric/Power BI; stays in tenant Source

09 / 10

What is the product built to become?

Purpose-built as a full AI analytics platform

Dot: Yes. Purpose-built for AI analytics across the full workflow
Power BI Copilot: No. A Microsoft BI suite adding AI across workflows

10 / 10

How do pricing and cost controls work?

Public, predictable pricing

Dot: Yes. Published tiers: Free, Pro $200/mo, Team $800/mo
Power BI Copilot: Partly. Public prices, but layered: seat, capacity, token metering Source

Hard usage limits, spend visibility, and ROI

Dot: Yes. Set usage limits; track spend and ROI
Power BI Copilot: Partly. Capacity controls spend; ROI tracked separately Source

Free tier or trial

Dot: Yes. Free plan, no credit card, unlimited users
Power BI Copilot: Partly. Free tier exists, but Copilot needs paid capacity Source

No new vendor to procure

Dot: No. Separate procurement and security review required
Power BI Copilot: Partly. Same vendor, but needs new paid capacity Source

Across all 43 capabilities

Dot36 supported2 partial5 not available

Power BI Copilot20 supported16 partial7 not available

Category	Decision point	Dot	Power BI Copilot
02 / 10Where can users receive answers?	Native Slack app	Yes. Native Slack app for business users	No. No Slack app; chat surface is Teams Source
	Native Microsoft Teams app	Yes. Native Teams app, not a pinned tab	Partly. Pins into Teams; AI chat needs M365 license Source
	Reachable over MCP from other assistants	Yes. MCP server reaches Claude, ChatGPT, MS Copilot	Partly. No documented MCP server; uses Copilot Studio Source
	Native mobile apps	No. Works in mobile browser; no native app	Yes. Native iOS and Android apps Source
03 / 10Which data sources can it access?	Warehouse and database connectors	Yes. 31 live connectors: Snowflake, BigQuery, Databricks, Redshift	Partly. Over 100 connectors; Copilot analyzes OneLake data Source
03 / 10Which data sources can it access?	Joins data across separate sources	Yes. Analysis across multiple warehouses	Partly. Up to 5 sources, all Fabric-native Source
04 / 10Which business context grounds its answers?	Grounded in dbt models and metrics	Yes. Uses dbt models and metrics as context	No. Runs dbt jobs; Copilot doesn't read dbt metrics Source
	Grounded in LookML	Yes. Uses Looker and LookML definitions as context	No. No LookML support; uses its own semantic model Source
	Your own metric and term definitions	Yes. Org-wide metrics and business-terms glossary, taught once	Partly. Per-model instructions/synonyms, hand-authored, still in preview Source
05 / 10How do you know the data is correct?	Shows the SQL behind every number	Yes. Click any number to see the SQL	Partly. "How Copilot arrived" panel shows fields and DAX Source
05 / 10How do you know the data is correct?	Regression tests for important questions	Yes. Per-org eval question suites plus feedback-driven improvement	Partly. Git-based ALM for agents; no eval suite Source
06 / 10Who owns and maintains the business logic?	Business context lives in a repository you own	Yes. Two-way sync with your GitHub or GitLab	Partly. Models support Git; verified answers do not Source
	Context and apps use Git and pull requests	Yes. Every publish is versioned through Git and PRs	Partly. Semantic models are reviewable and Git-ready Source
	Context stays current when schemas change	Yes. Schema changes trigger assisted context review	Partly. Agent audits models; authors approve updates Source
	Context remains portable if you leave	Yes. Readable context and apps stay in your repository	Partly. Human-readable TMDL exports, but Power BI-specific Source
07 / 10Which outputs can it produce?	Multi-step investigations, not just lookups	Yes. Multi-step investigation with parallel sub-agents, shows its plan	No. Can't do anomaly detection, forecasting, or key-influencer analysis Source
	Runs Python for statistical work	Yes. Uses Python for analysis beyond DAX	Partly. DAX in chat; Python is a separate tool Source
	White labeling and embedded analytics	Partly. Dashboard embedding; limited white-label controls	Yes. Embedded analytics for customer-facing applications Source
	Notebook or IDE for analysts	No. Runs Python internally; no analyst notebook workspace	Yes. Fabric notebooks: Python, PySpark, SQL, Scala for analysts Source
08 / 10Which governance and security controls are included?	Self-hosting available	Partly. Self-hosting only on Enterprise tier	No. SaaS-only; on-prem Report Server has no AI Source
08 / 10Which governance and security controls are included?	Uses the platform's native governance	No. Separate service; metadata and samples sync to Dot	Yes. Runs inside Fabric/Power BI; stays in tenant Source
09 / 10What is the product built to become?	Purpose-built as a full AI analytics platform	Yes. Purpose-built for AI analytics across the full workflow	No. A Microsoft BI suite adding AI across workflows
10 / 10How do pricing and cost controls work?	Public, predictable pricing	Yes. Published tiers: Free, Pro $200/mo, Team $800/mo	Partly. Public prices, but layered: seat, capacity, token metering Source
	Hard usage limits, spend visibility, and ROI	Yes. Set usage limits; track spend and ROI	Partly. Capacity controls spend; ROI tracked separately Source
	Free tier or trial	Yes. Free plan, no credit card, unlimited users	Partly. Free tier exists, but Copilot needs paid capacity Source
	No new vendor to procure	No. Separate procurement and security review required	Partly. Same vendor, but needs new paid capacity Source
Across all 43 capabilities		Dot36 supported2 partial5 not available	Power BI Copilot20 supported16 partial7 not available

Conclusion

Choose for the analytics stack you want to end up with

The decision is not only which tool answers questions today. It is which product can become your analytics platform over time.

Choose Power BI Copilot when Microsoft is already the company standard

Its semantic model supports row, column, and object-level security.
Power BI Pro comes with Microsoft 365 and Office 365 E5.
Report subscriptions support hourly delivery and five export formats.

Watch out

Complex DAX needs manual review. Practitioners describe incorrect or unusable DAX for complex measures, requiring manual checks and cleanup. ^[1][2][3]
Capacity use is hard to predict. A few prompts can consume substantial Fabric capacity, complicating rollout planning and competing with existing workloads. ^[1][2]

Pricing

Pro costs $14 per user monthly; Premium Per User costs $24.
Copilot also requires Fabric capacity, starting around $260 monthly.
Copilot is unavailable on the free tier.

Source

Choose Dot for best-of-breed AI analytics that can replace BI

Connect Dot to the data sources and semantic models you already have, then start with one agent. Context, apps, and business logic stay version-controlled in a repository you own, so they never become a Dot-only asset. Add dashboards, reporting, and governed workflows as adoption grows, then retire BI software you no longer need.

Watch out

Dot is growing quickly. Its smaller team may not offer the same level of hands-on support as a larger vendor in every region.

Pricing

Free plan, no credit card
Pro at $200/month, or $180/month billed annually. Unlimited users.
Team at $800/month, or $720/month billed annually. Adds single sign-on and row-level security.
Enterprise is custom: self-hosting, SLAs, and volume terms

Full pricing

Why the pricing model matters

Frontier AI has variable inference cost. A vendor that relies only on seat pricing must eventually meter AI, absorb the cost, or limit capability. Dot makes usage visible, lets teams set limits, and tracks the return on that spend.

Receipts

Benchmarked against human analysts, and measured in production

DABStep is Adyen’s public data-analysis benchmark. Dot scored above trained human analysts. It is independently published and available to inspect. In production, customers report these outcomes.

18× ROI

Choco, from time saved on analytics

12,000+ hours

saved every year at Duolingo, across 5,000+ tables

99% faster

time-to-insight at Emerge

€800K found

in a single investigation at KRY

Every Dot answer shows its work. Click any number to inspect the query.