Power BI
Power BI is Microsoft's business intelligence suite for connecting to data, modeling it, and building interactive reports and dashboards.
Overview
Power BI is Microsoft's BI product, distributed as a free desktop authoring tool (Power BI Desktop), a cloud service for publishing and sharing reports (Power BI Service), and now integrated into Microsoft Fabric. It's tightly woven into the Microsoft ecosystem — Excel, Azure, Teams, and SharePoint — which makes it a common default choice for organizations already standardized on Microsoft tools.
How it works
Data is imported or connected through Power Query, a low-code data-shaping tool built on the M language, then modeled into tables and relationships. Calculated columns and measures are written in DAX (Data Analysis Expressions), a formula language purpose-built for aggregations across a relational data model. Reports can run in Import mode (data cached in Power BI's in-memory VertiPaq engine for speed) or DirectQuery mode (queries pushed live to the source on every interaction).
Copy code
Total Revenue = SUM(Orders[OrderTotal]) Revenue LY = CALCULATE( [Total Revenue], SAMEPERIODLASTYEAR('Date'[Date]) )
Power BI and DuckDB
Power BI doesn't ship a native DuckDB connector, but MotherDuck publishes an open-source DuckDB Power Query custom connector that uses the DuckDB ODBC driver under the hood. After installing the DuckDB ODBC driver and the connector's .mez file, and enabling custom extensions in Power BI's security settings, Power BI Desktop can connect to a local DuckDB file or, using the md: prefix with a MotherDuck token, directly to a MotherDuck cloud database — letting Power BI reports pull from DuckDB-backed pipelines without an intermediate export step.
Related terms
Business Intelligence (BI) refers to the technologies, applications, and practices used to collect, integrate, analyze, and present business information.
MotherDuck extension →The MotherDuck extension is a component of DuckDB that enables seamless integration with the MotherDuck cloud service.
Snowflake (data cloud) →Snowflake is a cloud data platform that separates storage, compute, and services into independent layers, letting you scale query power without moving the underlying data.
MotherDuck →MotherDuck is a cloud-based analytics platform built on top of DuckDB that enables teams to analyze and share data without managing complex infrastructure.
Tableau →Tableau is a data visualization and business intelligence platform, owned by Salesforce, known for interactive drag-and-drop dashboards built on its VizQL engine.
Metabase →Metabase is an open-source business intelligence tool that lets people explore data, build charts, and share dashboards through a simple query builder or raw SQL.
FAQS
Power BI Desktop, the authoring tool, is free. Publishing and sharing reports through the Power BI Service generally requires a Power BI Pro or Premium license per user or capacity.
Yes, using MotherDuck's open-source DuckDB Power Query custom connector, which relies on the DuckDB ODBC driver and supports both local DuckDB files and MotherDuck cloud databases.
Import mode loads data into Power BI's in-memory engine for fast local performance, refreshed on a schedule. DirectQuery sends queries to the source system live on every interaction, trading some speed for always-current data.
