Quickstart: learn about the Power BI capabilities for business users

APPLIES TO: Power BI service for business users Power BI service for designers & developers Power BI Desktop Requires Pro or Premium license

This quickstart demonstrates how to interact with the Power BI service to discover data-driven business insights. This article isn't intended to be a deep dive, but rather a quick trip through many of the actions available for Power BI business users.

If you're not signed up for the Power BI service, sign up for a free trial before you begin.

What is Power BI?

Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Your data might be a simple Excel spreadsheet or a collection of data from different data sources. No matter, Power BI lets you easily connect to your data sources, visualize (or discover) what's important, and share that with anyone or everyone you want.

Screenshot illustrating Power BI getting content from various sources and outputting a report.

Open the Power BI service, in a browser or on a mobile device. You and your colleagues work from the same trusted apps, dashboards, and reports, that update and refresh automatically, so you're always working with the freshest content.

Reading view

There are two modes for interacting with reports in the Power BI service: Editing view and Reading view. If you're a business user, then you're more likely to use Reading view to consume reports created by others. Editing view is used by report designers, who create the reports and share them with you. Reading view is your way to explore and interact with reports created by colleagues.

Select Editing view and Reading view

Most reports open in Reading view. To switch from Reading view to Editing view, select Edit from the action bar. If Edit is grayed out, that means that you don't have permissions to edit the report.

Screenshot of action bar with the word Edit outlined in red.

To switch back to Reading view, select Reading view from the action bar.

Screenshot showing action bar with the words Reading view outlined in red.

Even in Reading view, the content isn't static. You can dig in, looking for trends, insights, and other business intelligence. Slice and dice the content, and even ask it questions using your own words. Or, sit back and let your data discover interesting insights for you; send you alerts when data changes, and email reports to you on a schedule you set. All your data, anytime, in the cloud or on-premises, from any device.

Read on to learn about these features and more.

Power BI content

When we use the term "content" in Power BI, we're referring to items such as reports, dashboards, and apps. This content is the building blocks you use to explore your data and make business decisions.

Note

Dashboards, reports, and apps can be viewed and shared on mobile devices, too.

Apps

An app is a Power BI content type that combines related dashboards, reports, workbooks, and more all in one place. An app can have one or more dashboards and one or more reports, all bundled together. Power BI designers create apps and distribute and share the apps with business users like you.

One way to view your apps is to select Apps from the nav pane and choose an app to open.

Screenshot of Apps screen showing eight different apps.

To learn more about viewing apps, see Power BI apps.

Reports

A Power BI report is a multi-perspective view into a semantic model, with visuals that represent different findings and insights from that semantic model. A report can have a single visual or pages full of visuals. Power BI designers create reports and distribute and share the reports with business users like you.

Art showing the same report on both a cellphone and a computer browser.

To learn how to view reports, see Power BI reports.

Dashboards

A Power BI dashboard is a single page, often called a canvas, that uses visualizations to tell a story. Because it's limited to one page, a well-designed dashboard contains only the most-important elements of that story.

The visualizations you see on the dashboard are called tiles and are pinned to the dashboard by report designers. In most cases, selecting a tile takes you to the report page where the visualization was created.

Art showing the same dashboard displayed on a cellphone and in a computer browser screen.

To learn how to view dashboards, see Power BI dashboards.

Interact in the Power BI service

Collaborate with colleagues

Skip the email. Add a personal comment or start a conversation with colleagues about a dashboard, right there on that dashboard. The comment feature is just one of the ways you can collaborate with others.

commenting video

Learn more about commenting.

Sit back and let Power BI work for you

Two of the ways that the Power BI service does the work for you is with subscriptions and alerts.

Subscribe to a dashboard (or report)

It's not necessary to open Power BI to monitor a dashboard. You can subscribe instead, and Power BI emails you a snapshot of that dashboard on a schedule you set.

select the Subscribe icon.

Learn more about Power BI subscriptions.

Get alerts when your data reaches a threshold

Your data is live, and your visuals update automatically. If you want to get notified when data changes above or below a threshold you set, use data alerts. Alerts work on gauges, KPIs, and cards.
Screenshot showing gauge, kpi, and card.

Power BI sends you an email when the value increases or decreases past the limit you set.
Alert email.

Learn more about Power BI alerts.

Use Q&A to ask questions using natural language

Sometimes the fastest way to get an answer from your data is to ask a question using natural language. The Q&A question box is available at the top of your dashboard. For example, "show me count of large opportunities by sales stage as a funnel."

Q&A

Learn more about Power BI Q&A.

Display details on a visualization

Visuals are made up of datapoints, and by hovering over a datapoint, you can view the details.

hover to see details

Adjust the display dimensions

Reports are viewed on many different devices, with varying screen sizes and aspect ratios. The default rendering may not be what you want to see on your device.

To adjust, from the upper right menu bar select the View icon and choose one of the display options.

report View menu

See how all the visuals on a page are interconnected

Cross-highlight and cross-filter the related visualizations on a report page. The visualizations on a single report page are all "connected" to each other. What this means is that if you select one or more values in one visualization, other visualizations that use that same value change based on your selection.

cross highlight

Learn more about visual interactions.

Update the filters used in the report

Open the Filters pane to reveal the filters applied to the page, report, and visualization.

Screenshot of the Filters pane expanded.

If the report has filters applied, they'll display in the Filters pane. Make changes to the filters to see the effect on the visuals. Save your changes, or use the Reset icon to revert to the default report page state.

Zoom in on individual visuals

Hover over a visual and select the Focus mode icon select Focus mode from menu . When you view a visualization in Focus mode, it expands to fill the entire report canvas.

Screenshot with arrow pointing to the icon for Focus mode.

Screenshot showing the focus mode visual filling the entire canvas.

To display that same visualization without the distraction of menu bars, filter pane, and other chrome--select Full screen from the View dropdown.

Screenshot showing the dropdown menu for View.

Screenshot showing same visual in full screen mode.

Learn more about focus mode and full screen mode.

Sort a visualization

Visuals on a report page can be sorted and saved with your changes applied.

Hover over a visual to make it active, and select More options (...) to open sorting options.

sort a chart

Learn more about sorting visuals.

Show the data used to create a visualization

A Power BI visualization is constructed using data from underlying semantic models. If you're interested in seeing behind-the-scenes, Power BI lets you display the data that is being used to create the visual. When you select Show as a table, Power BI displays the data below (or next to) the visualization.

With a visual active, select More options (...) and choose Show as a table.

Screenshot showing an area chart at top and a table with the data below.

Export data to Excel

In addition to showing the data that is used to create a visual, you can also export that data and view it in Microsoft Excel. When you export to Excel, you're creating a separate document, a spreadsheet that isn't part of Power BI. Any changes that you make in the Excel file don't impact the data in Power BI. Whether you want to take a closer look at the data, or you want to use the data in another application or for another purpose, Power BI gives you that flexibility. For more information, visit Export the data that was used to create a visualization.

Exporting isn't limited to individual visuals; you can export entire reports to Excel or PowerPoint to share with your colleagues. For more information, see Analyze in Excel and Power BI in PowerPoint.

This article is a quick overview of just some of the things business users can do with the Power BI service.

Clean up resources

  • If you connected to an app, from the nav pane, select Apps to open the Apps content list. Hover over the app to delete, and select the trashcan icon.

  • If you imported or connected to a Power BI sample report, from the nav pane, open My workspace. Using the tabs at the top, locate the dashboard, report, and semantic model, and select the trashcan icon for each.