Power BI Fundamentals
Power BI is Microsoft's business analytics platform for turning source data into governed semantic models, interactive reports, dashboards, and shared apps. Power BI Desktop supports report development, while the Power BI service supports collaboration, distribution, refresh, and access control.
itData engineering and analytics | OpenSkills.info
Course pathWalk it in order
Look it upDip in anytime
Go furtherLeaves this page
Don't Panic
Don't Panic — Power BI Fundamentals
Power BI is the place where a source table puts on a respectable shirt, learns the business vocabulary, and becomes a report someone can use. It is not the chart itself. The chart is the last stop on a longer journey, which is why asking it to repair bad data is rather like asking a thermometer to cure a fever.
The useful chain is Power Query, semantic model, DAX, report, and service. Power Query records repeatable preparation steps. The semantic model holds tables, relationships, measures, formatting, and security. DAX supplies calculations that respond to the filters in the current view. A report lets people explore those calculations. The service provides workspaces, refresh, sharing, dashboards, and apps. Each part has a different job, despite the collective tendency to call the whole arrangement “the dashboard.”
The key idea is grain: what one fact row represents. One order, one order line, and one daily total are not interchangeable merely because they all contain numbers. State the grain before adding measures. Then use a star schema so descriptive dimensions such as Date or Product filter the facts that those measures summarize. This sounds fussy because it is fussy. It is also cheaper than explaining a convincing wrong total to a room full of people.
The surprise is that a measure does not keep one fixed answer. Filter context is the set of filters from a visual, slicer, relationship, or security rule. The formula can remain unchanged while its result differs by month, product, region, or viewer. That is the point. It is also why relationships and security deserve more attention than a color palette.
There is another choice hiding under every report: where data is queried. Import keeps a copy in the model and needs refresh. DirectQuery asks the source when a visual runs and inherits the source, network, gateway, and query-design delays. Neither choice is a moral achievement. It is an arrangement for a particular freshness, volume, and performance problem.
When something fails, follow the chain in the direction the data travelled: source, query steps, grain, relationship, measure, filters, identity, then the visual. The Intro explains the full route and its limits. Slides show the connections at a glance. Cheatsheet is the compact reference for storage, refresh, permissions, and troubleshooting. The Exercise turns the pieces into a small report whose filters have to behave in public, where they are considerably less inclined to bluff.
Where this skill leads
Relevant careers
See how this topic contributes to broader role-level skill maps.
Sources
- https://learn.microsoft.com/en-us/power-bi/fundamentals/power-bi-overview
Supports
- Power BI as Microsoft's business analytics platform and a core Microsoft Fabric workload
- Roles of Power BI Desktop, the Power BI service, reports, and dashboards
- Power BI and Microsoft Fabric relationship
- https://learn.microsoft.com/en-us/power-bi/fundamentals/desktop-getting-started
Supports
- Desktop connection, transformation, visualization, save, and publish flow
- Power Query Editor use within Power BI Desktop
- Publication from Desktop to the Power BI service
- https://learn.microsoft.com/en-us/power-bi/fundamentals/service-basic-concepts
Supports
- Definitions of semantic model, visualization, report, dashboard, app, workspace, and capacity
- Reports as pages based on one semantic model and dashboards as single canvases
- Workspace roles and app distribution concepts
- https://learn.microsoft.com/en-us/power-bi/connect-data/service-datasets-understand
Supports
- Semantic models as containers used by reports, dashboards, and apps
- Power BI Desktop models as Analysis Services tabular models
- https://learn.microsoft.com/en-us/power-query/power-query-what-is-power-query
Supports
- Power Query as a data transformation and preparation engine
- Graphical connection and repeatable query transformations
- Refreshable extract, transform, and load processing
- https://learn.microsoft.com/en-us/power-bi/transform-model/
Supports
- Power BI transformation, shaping, relationship, modeling, DAX, and dataflow documentation path
- https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
Supports
- Star schema guidance for Power BI semantic models
- Fact and dimension table roles, grain, and relationship design
- Data warehouse recommendation for large-volume or advanced transformation requirements
- https://learn.microsoft.com/en-us/dax/
Supports
- DAX as functions and operators used for formulas in Power BI and tabular models
- DAX reference, statements, syntax, operators, and query resources
- https://learn.microsoft.com/en-us/dax/dax-overview
Supports
- DAX calculations, formulas, functions, variables, data types, and context
- DAX use across Power BI, Power Pivot, and Analysis Services
- https://learn.microsoft.com/en-us/dax/dax-glossary
Supports
- Analytic-query filtering, grouping, and summarization
- Row context and filter context definitions
- BLANK, measures, RLS, and dynamic security vocabulary
- https://learn.microsoft.com/en-us/power-bi/connect-data/service-dataset-modes-understand
Supports
- Import, DirectQuery, Composite, Dual, and hybrid model behavior
- Import performance, memory, and refresh tradeoffs
- DirectQuery source-query behavior, freshness rationale, limitations, and resource pressure
- https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about
Supports
- Import versus DirectQuery query paths and limitations
- Hybrid, Direct Lake, live connection, and composite alternatives
- https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-data
Supports
- Data, schema, visual, tile, query-cache, and OneDrive refresh distinctions
- Gateway and credential requirements for sources not directly reachable by the service
- Source schema changes as causes of broken queries, model objects, and visuals
- https://learn.microsoft.com/en-us/fabric/security/service-admin-row-level-security
Supports
- Row-level security roles and identity-based row filtering
- RLS limitations and differences across connection and workspace contexts
- Need to validate dynamic RLS with production-like identities
- https://learn.microsoft.com/en-us/fabric/security/security-overview
Supports
- Workspace access and item sharing as distinct access layers
- RLS, column-level security, and object-level security as data restrictions
- https://learn.microsoft.com/en-us/power-bi/guidance/powerbi-implementation-planning-usage-scenario-managed-self-service-bi
Supports
- Shared semantic models supporting multiple report creators
- Managed self-service publication and governance arrangement
- https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-external-tools
Supports
- External Tools integration with the Analysis Services model hosted by Desktop
- Roles of DAX Studio, Tabular Editor, ALM Toolkit, and other external tools
- Caution for external model write operations
- https://github.com/sindresorhus/awesome
Supports
- Required Awesome discovery starting point
- Discovery route to topic-specific curated lists
- https://github.com/NajiElKotob/Awesome-Power-BI
Supports
- Discovery of DAX Studio, Tabular Editor, Power BI Helper, and other Power BI ecosystem resources
- Curated Power BI tools, learning, reference, and community categories
- https://daxstudio.org/docs/features/traces/server-timings-trace/
Supports
- Server-side DAX query duration and storage-engine timing inspection
- Formula-engine and storage-engine diagnostic workflow
- https://docs.tabulareditor.com/en/tutorials/new-pbi-model.html
Supports
- Creation and editing of Power BI semantic models in Tabular Editor
- Power Query expression and model metadata support
- https://bravo.bi/
Supports
- Bravo model analysis, DAX formatting, date-table management, and data export features
- Bravo as a Power BI companion tool
- https://www.microsoft.com/en-us/sql-server/blog/2009/11/18/powerpivot-downloads-for-excel-and-sharepoint-now-available/
Supports
- November 2009 PowerPivot preview downloads for Excel 2010 and SharePoint 2010
- Self-service in-memory modeling and browser sharing roots of the later Power BI stack
- https://www.microsoft.com/en-us/sql-server/blog/2013/07/08/introducing-power-bi-for-office-365/
Supports
- July 2013 introduction of the Power BI for Office 365 name and offering
- Combination of Excel self-service BI and Office 365 sharing
- https://powerbi.microsoft.com/en-ie/blog/announcing-power-bi-general-availability-coming-july-24th/
Supports
- Power BI general availability date of July 24 2015
- Power BI Desktop's earlier Power BI Designer name and free-form report authoring role
- https://powerbi.microsoft.com/en-nz/blog/announcing-general-availability-of-power-bi-gateway-for-enterprise-deployment/
Supports
- February 2016 general availability of the enterprise Power BI gateway
- Centralized access to supported on-premises data sources
- https://powerbi.microsoft.com/en-cy/blog/power-bi-report-server-preview-now-available/
Supports
- 2017 introduction and planned general availability of Power BI Report Server with Power BI Premium
- On-premises publication and viewing path for Power BI reports
- https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-2018-feature-summary/
Supports
- November 2018 general availability of composite models
- Combination of DirectQuery and Import sources in one model
- https://powerbi.microsoft.com/de-at/blog/announcing-deployment-pipelines-general-availability-ga/
Supports
- September 2020 general availability of deployment pipelines
- Development, test, and production stages for managed Power BI content delivery
- https://www.microsoft.com/en-us/microsoft-fabric/blog/2023/11/15/prepare-your-data-for-ai-innovation-with-microsoft-fabric-now-generally-available/
Supports
- November 2023 general availability of Microsoft Fabric
- Power BI as a Fabric workload with OneLake and Direct Lake integration
- https://powerbi.microsoft.com/
Supports
- Microsoft Power BI product homepage and official destination
- https://help.tableau.com/current/tableau/en-us/tableau_product_overview.htm
Supports
- Tableau Desktop, Cloud, Server, Prep, Mobile, and Public product roles
- Tableau visual analytics and deployment choices
- https://help.qlik.com/en-US/sense/May2026/Subsystems/Hub/Content/Sense_Hub/Introduction/qlik-sense-product-family.htm
Supports
- Qlik Sense governed self-service, associative exploration, embedded, cloud, and client-managed roles
- https://docs.aws.amazon.com/quicksight/latest/user/how-quicksight-works.html
Supports
- Amazon QuickSight preparation, SPICE or direct-query paths, analyses, visuals, and dashboards
- https://www.metabase.com/home
Supports
- Metabase open-source and hosted business intelligence options
- Self-service exploration, visualization, permissions, and embedding roles
- https://superset.apache.org/docs/
Supports
- Apache Superset as an open-source data exploration and visualization platform
- SQL editor, semantic layer, datasets, charts, dashboards, security, and supported databases
- https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-excel-stunning-report
Supports
- Power BI Desktop financial-sample tutorial with data preparation, an explicit DAX measure, visuals, a slicer, and optional service publication
- Observable end-to-end practice workflow for a report built from the Financial Sample workbook