Power BI Desktop Setup

Analogy categoryAnalogies

Installing Power BI Desktop

Power BI Desktop is free and can be installed either from the Microsoft Store (which auto-updates) or via a standalone .exe installer from Microsoft's website, which is preferred in locked-down corporate environments where the Store is disabled. It runs on Windows 10 or later and requires no license to install or use for local authoring; signing in with a Microsoft work or school account is only needed once you want to publish reports to the Power BI Service. Microsoft ships a new Desktop release roughly every month, adding new visuals, DAX functions, and connectors.

🏏

Cricket analogy: Installing Power BI Desktop is like a young cricketer signing up for free nets access at a local academy — no cost barrier before you can start practicing your shots.

Touring the Interface: Report, Data, and Model Views

Power BI Desktop organizes work into three views accessible from icons on the left edge. Report view is the canvas where you drag fields onto visuals and design pages. Data view shows every table in your model as a flat grid, useful for spot-checking values and adding calculated columns. Model view shows a diagram of every table and the relationships connecting them, letting you drag lines between fields to create relationships, set cardinality, and control cross-filter direction visually.

🏏

Cricket analogy: Report view is like the matchday scoreboard fans see, Data view is like the raw scorebook with every ball recorded, and Model view is like the team sheet showing how players relate to their roles.

Ribbon and Panes

The Home ribbon houses the two most important buttons for starting a new report: Get Data, which opens the connector list, and Transform Data, which opens the Power Query Editor for cleaning a source before it loads. On the right side of Report view, the Fields pane lists every table and column in your model to drag onto visuals, the Visualizations pane lets you pick chart types and format them, and the Filters pane controls visual-, page-, and report-level filtering.

🏏

Cricket analogy: The Get Data button is like a scout heading out to collect player stats, Transform Data is like the analyst cleaning up scorecards, and the Fields pane is like a team roster you drag players from onto the field diagram.

Configuring Options and Settings

File > Options and settings > Options exposes both global settings (applying to every file you open) and current-file settings. Common early configurations include disabling 'Auto Date/Time' for new files if you plan to build your own date dimension table, setting the regional format used for parsing numbers and dates on import, and opting into preview features under the Preview features tab to try upcoming DAX functions or visuals before they ship broadly.

🏏

Cricket analogy: Configuring regional settings is like a commentator switching between metric and imperial pitch measurements depending on the broadcast country's audience.

powerquery-m

// A step visible in the Power Query Advanced Editor after using Get Data > Excel
let
    Source = Excel.Workbook(File.Contents("C:\Data\Sales.xlsx"), null, true),
    Sales_Sheet = Source{[Item="Sales",Kind="Sheet"]}[Data],
    PromotedHeaders = Table.PromoteHeaders(Sales_Sheet, [PromoteAllScalars=true]),
    ChangedType = Table.TransformColumnTypes(
        PromotedHeaders,
        {{"OrderDate", type date}, {"Amount", type number}}
    )
in
    ChangedType

Learn the keyboard shortcut Ctrl+E to quickly reopen the Power Query Editor, and Ctrl+S to save your .pbix frequently — Desktop does not autosave, and unsaved model or DAX changes are lost if the application closes unexpectedly.

Power BI Desktop only runs natively on Windows — Mac users must use a Windows VM, Parallels, or Remote Desktop, since there is no native macOS build. The Power BI Service, by contrast, is fully browser-based and works on any operating system.

Power BI Desktop installs free via the Microsoft Store or a standalone installer, with no license needed for local authoring.
The three main views are Report (canvas), Data (grid), and Model (relationship diagram).
The Home ribbon's Get Data and Transform Data buttons are the starting point for every new report.
The Fields, Visualizations, and Filters panes are the core panes used while building visuals.
File > Options and settings controls both global and per-file configuration, including regional format and preview features.
Desktop is Windows-only; Mac users need a VM or Remote Desktop to run it natively.
Desktop ships monthly updates, so keep it current to access new DAX functions and visuals.