What a Power BI dashboard actually is

A Power BI dashboard is a single page that displays data in visual form — charts, tables, maps, gauges — all pulled from your data sources and updated automatically. It is not a report (which can be multiple pages with more detail), and it is not a spreadsheet (which sits in one place and does not refresh on its own). A dashboard is meant to be glanced at quickly to see the current state of something: sales this month, website traffic today, inventory levels right now.

Power BI is Microsoft's tool for this work. You connect it to databases, spreadsheets, cloud services, or other data sources, tell it which numbers or categories matter to you, and it builds the visuals. The dashboard updates on a schedule you set — every hour, every day, or whenever the source data changes. You can share it with colleagues or clients, and they see the same live numbers you do.

Key Takeaways

  • A Power BI dashboard pulls data from your sources automatically and displays it as charts and tables on a single page that updates on schedule.
  • You start by connecting to your data source (a spreadsheet, database, or cloud service), loading the data into Power BI, and then creating visuals from the fields you choose.
  • Visuals are interactive — clicking a bar chart filters the other charts on the page to show only that category's data.
  • Dashboards are shared as links that colleagues can view in a web browser without needing Power BI installed on their computer.
  • The free version of Power BI Desktop lets you build dashboards, but sharing them requires a paid Power BI service subscription.

The difference between Power BI Desktop and Power BI Service

Power BI comes in two parts. Power BI Desktop is the free software you read to your computer — it is where you actually build dashboards. You connect to your data, create the visuals, arrange them on the page, and save your work as a .pbix file. This part costs nothing.

Power BI Service is the online version where dashboards live after you publish them. It is where other people view your dashboard, where the data refreshes on schedule, and where you manage who can see what. Power BI Service requires a paid subscription — either a per-user license (Power BI Pro, around $10 per person per month) or a capacity license (Power BI Premium, which covers many users and costs more upfront). If you only want to build dashboards for yourself and never share them, Desktop alone is free. If you want others to see your work, you need Service.

How to connect your data and load it into Power BI

Open Power BI Desktop and look for the Get Data button on the Home tab. This opens a window with dozens of options: Excel, SQL Server, Google Analytics, Salesforce, SharePoint, and many others. Choose the source where your data lives.

If you are connecting to an Excel file, you will browse to the file on your computer and select which sheets or tables to load. If you are connecting to a database, you will enter the server address and credentials. If you are connecting to a cloud service like Google Analytics or Salesforce, you will log in and authorize Power BI to read your data.

Once you choose your source, Power BI shows you a preview of the data — the column names and the first few rows. You can filter out columns you do not need or rows that do not matter. Then you click Load and Power BI pulls the data into its memory. This is now your dataset, and you can build visuals from any of the columns in it.

Creating your first visuals

After your data loads, you see the Fields panel on the right side of the screen. This lists every column in your dataset. To create a visual, drag a field onto the blank canvas in the center. Power BI guesses what kind of chart makes sense — if you drag a text field, it might create a bar chart; if you drag a number, it might create a gauge or line chart.

You can change the visual type by clicking the icon in the top-left corner of the visual. A column chart can become a line chart, a pie chart, a table, or a map. Each visual type has a Visualizations panel below the Fields panel where you can adjust colors, labels, data labels, and other details.

Most dashboards have between three and eight visuals — enough to tell the story without overwhelming the viewer. A sales dashboard might show total revenue this month, revenue by region, revenue by product, and a trend line over the past year. Each visual answers one question.

Making visuals talk to each other

One of the most useful features of a Power BI dashboard is cross-filtering. When you click on one visual, the others on the page filter to show only the data you clicked. For example, if your dashboard has a bar chart of sales by region and a line chart of sales over time, clicking on the "West" bar will make the line chart show only West region sales.

This happens automatically for most visuals — you do not have to set it up. If you want to turn it off for a specific visual, right-click the visual and choose Edit interactions. You can then decide whether clicking other visuals filters this one, or whether this visual filters others, or neither.

You can also add a slicer — a dropdown or list that filters everything on the page at once. If you add a slicer for "Month", everyone viewing the dashboard can pick a month and see all the visuals update to show only that month's data. Slicers are especially useful when you want viewers to explore the data themselves without building separate dashboards for each scenario.

Arranging and formatting your dashboard

Power BI dashboards use a grid layout. Each visual snaps to the grid as you drag it around. You can resize visuals by dragging their corners, and you can stack them however you want. Most dashboards arrange the most important metric at the top left (where eyes naturally go first) and supporting details below or to the right.

You can add a title to your dashboard by inserting a text box. Click Insert on the Home tab, then Text box, and type your title. You can also add a background image or change the background color. These formatting choices do not affect how the data works — they just make the dashboard easier to read and more professional to share.

Before you publish, take a moment to view your dashboard as others will see it. Click the View tab and choose Reading view to see how it looks without all the editing tools. This is the view your colleagues will see when you share the link with them.

Publishing your dashboard and sharing it

Once your dashboard is ready, click Publish on the Home tab. Power BI asks you to choose a workspace — if this is your first time, you will publish to "My workspace". Power BI uploads your .pbix file to Power BI Service and converts it into a dashboard that lives online.

To share the dashboard with others, go to Power BI Service in your web browser, find your dashboard, and click the Share button. You enter the email addresses of the people you want to share with, and they receive an email with a link. They can click the link and view the dashboard in their browser — they do not need Power BI installed, and they do not need a Power BI license (though your organization pays for the license that hosts the dashboard).

If you want to share with people outside your organization, or if you want to embed the dashboard in a website, the process is different and usually requires additional permissions or a Power BI Premium license. Check with your IT department or Power BI administrator about what your organization allows.

Keeping your dashboard data fresh

After you publish, your dashboard data needs to refresh — to pull the latest numbers from your source. You set up a refresh schedule in Power BI Service. Click the three dots next to your dataset name, choose Settings, then Scheduled refresh. You can set Power BI to refresh once a day, twice a day, or up to eight times a day, depending on your subscription level.

Some data sources require a gateway — a small piece of software that sits on your company's network and lets Power BI Service reach databases or files that are not on the internet. If your data lives on a local server rather than in the cloud, your IT team will need to set up a gateway. If your data is in Excel Online, Google Sheets, or a cloud database, you do not need a gateway.

If a refresh fails, Power BI sends you an email. Common reasons include wrong credentials, the data source being offline, or the file being moved. Check the refresh history in Settings to see what went wrong, fix the issue, and Power BI will try again at the next scheduled time.

Frequently Asked Questions

Can I build a dashboard without knowing how to code?

Yes. Power BI is designed for people who know their data but not programming. You point and click to connect sources, drag fields to create visuals, and arrange them on a page. No coding required. If you want to do advanced calculations or transformations, you can learn Power Query or DAX (Power BI's formula language), but basic dashboards need neither.

What happens if my data source goes offline?

Your dashboard will show the last data it successfully loaded, but it will not update until the source comes back online. Power BI will keep trying to refresh on schedule. Once the source is back, the next refresh will pull the new data. You will see an error message in Power BI Service if a refresh fails repeatedly.

Can multiple people edit the same dashboard?

Not at the same time. Only one person can edit a dashboard in Power BI Desktop at a time. If you want multiple people to work on the same dashboard, you can take turns editing and re-publishing, or you can use Power BI's collaboration features in Service (like commenting on visuals). For true simultaneous editing, you would need to use Power BI Premium and Shared Capacity.

How much does it cost to share a dashboard with my team?

If your team members have Power BI Pro licenses (around $10 per person per month), they can view and interact with shared dashboards. If they do not have licenses, your organization can buy a Power BI Premium capacity license instead, which covers unlimited viewers. The cost depends on your organization's size and how much data you are storing.

Can I make a dashboard that updates in real time?

Power BI can refresh as often as every 15 minutes with a Pro license, or every minute with a Premium license. True real-time streaming (updates every second) requires a special setup called a streaming dataset, which is more complex. For most business dashboards, hourly or daily refresh is enough.