| Primary purpose | Different approachAnswer ad-hoc business questions in plain English. | Different approachModel data and publish governed reports and dashboards. |
|---|
| Getting to a first answer | SupportedConnect a source and ask. A semantic layer can be generated or defined, but is not required to start. | SupportedBuild or reuse a semantic model, then a report. Microsoft advises preparing the model for Copilot to answer reliably. |
|---|
| Natural-language questions | SupportedPlain-English questions become SQL that runs on your connected sources. The SQL is shown with the result. | Depends on plan or setupCopilot answers from semantic models. Requires paid Fabric capacity (F2 or higher) or Premium P1; Pro or PPU alone is not enough. |
|---|
| Report and dashboard depth | Partially supportedDashboards with 18 chart types, filters, drill-down and calculated fields. Less design depth than Power BI. | SupportedA core strength, with a wide visual library and custom visuals. |
|---|
| Data modeling | Partially supportedA semantic layer of measures, dimensions and relationships, defined or generated from the schema. | SupportedMature modeling with DAX, relationships and large models. |
|---|
| Data sources | Supported32 connector implementations covering 34+ sources: databases and warehouses, business apps (Salesforce, HubSpot, Stripe, Razorpay, Zoho CRM and more) and CSV, XLSX and JSON files. | SupportedA very wide range of Microsoft and third-party connectors. |
|---|
| Showing the work | SupportedEach answer shows its SQL, and the tables and columns it used are recorded as lineage. Failed queries are repaired and retried with per-attempt history. | Partially supportedCopilot answers are grounded in the semantic model; DAX can be inspected by authors. |
|---|
| Row-level security | SupportedRole-based table access, column masking (redact, hash, partial, deny) and row-level filters applied when each query runs. | SupportedRow-level security on semantic models, plus Microsoft Purview integration. |
|---|
| Working together | SupportedOData v4 endpoint for Power BI; import of supported .pbix files. | SupportedCan consume Zenzo results through the OData endpoint. |
|---|
| Pricing model | SupportedPublished prices, per workspace rather than per user. Viewers are free on paid plans; there is a free plan and a 14-day Business trial. | SupportedPublished per-user pricing, plus Fabric capacity for Copilot and larger deployments. |