This tutorial is an introduction to some of the features of the Power BI service. In it, you connect to data, create a report and a dashboard, and ask questions of your data. You can do much more in the Power BI service; this tutorial is just to whet your appetite. For an understanding of how the Power BI service fits in with the other Power BI offerings, we recommend reading What is Power BI.
In this tutorial, you complete the following steps:
- Sign in to your Power BI online account, or sign up, if you don't have an account yet.
- Open the Power BI service.
- Get some data and open it in report view.
- Use that data to create visualizations and save it as a report.
- Create a dashboard by pinning tiles from the report.
- Add other visualizations to your dashboard by using the Q&A natural-language tool.
- Resize, rearrange, and edit details for the tiles on the dashboard.
- Clean up resources by deleting the dataset, report, and dashboard.
Sign up for the Power BI service
Step 1: Get data
Often when you want to create a Power BI report, you start in Power BI Desktop. Power BI Desktop offers more power. You can transform, shape, and model data, before you start designing report. This time though, we're going to start from scratch creating a report in the Power BI service.
2. Select My workspace in the navigation pane.
3. In My workspace, select New > Upload a file.
The Get Data page opens.
4. Under the Create new content section, make sure Files is selected, then select the location where you saved the Excel file.
5. Browse to the file on your computer, and choose Open.
6. For this tutorial, we select Import to add the Excel file as a dataset, which we can then use to create reports and dashboards. If you select Upload, the entire Excel workbook is uploaded to Power BI, where you can open and edit it in Excel Online.
7. When your dataset is ready, select More options (...) next to your Financial Sample dataset, then select Create report.
8. open the report editor.
The report canvas is blank. We see the Filters, Visualizations, and Fields panes on the right.
Select the global navigation button in the upper-left corner to collapse the navigation pane. That way your canvas has more room.
9. You're currently in Editing view. Notice the Reading view option in the menu bar.
While in Editing view, you can modify reports, because you're the owner and creator of the report. When you share your report with colleagues, often they can only interact with the report in Reading view. They are consumers of reports in your My workspace.
Step 2: Create a chart in a report
Now that you've connected to data, start exploring. When you've found something interesting, you can save it on the report canvas. Then you can pin it to a dashboard to monitor it and see how it changes over time. But first things first.
1. In the report editor, start in the Fields pane on the right side of the page to build a visualization. Select the Gross Sales field, then the Date field.
Power BI analyzes the data and creates a column chart visualization.
NoteIf you selected the Date field first instead of Gross Sales, you see a table. No worries! We're going to change the visualization in the next step.
Some fields have sigma symbols next to them because Power BI detected that they contain numeric values.
2. Let's switch to a different way of displaying this data. Line charts are good visuals for displaying values over time. Select the Line chart icon from the Visualizations pane.
3. This chart looks interesting, so let's pin it to a dashboard. Hover over the visualization and select the pin icon.
4. Because this report is new, you're prompted to save it before you can pin a visualization to a dashboard. Give your report a name (for example, Financial Sample report), then Save.
Now you're looking at the report in Reading view.
5. Select the Pin icon again.
6. Select New dashboard and name it Financial Sample dashboard, for example.
A success message (near the top-right corner) lets you know the visualization was added as a tile to your dashboard.
Now that you've pinned this visualization, it's stored on your dashboard. The data stays up-to-date so you can track the latest value at a glance. However, if you change the visualization type in the report, the visualization on the dashboard doesn't change.
7. Select Go to dashboard to see your new dashboard with the line chart that you pinned to it as a tile.
8. Select the new tile on your dashboard. Power BI returns you to the report in Reading view.
9. To switch back to Editing view, select More options (...) in the menu bar > Edit.
Back in Editing view, you can continue to explore and pin tiles.
Step 3: Explore with Q&A
For a quick exploration of your data, try asking a question in the Q&A question box. Q&A lets you ask natural-language queries about your data. In a dashboard, the Q&A box is at the top (Ask a question about your data) under the menu bar. In a report, it's in the top menu bar (Ask a question).
1. To go back to the dashboard, select My workspace in the black Power BI header bar.
2. In My workspace, select your dashboard.
3. Select Ask a question about your data. Q&A automatically offers a number of suggestions.
If you don't see the suggestions, turn on New Q&A experience.
4. Some suggestions return a single value. For example, select what is the average cog.
Q&A searches for an answer and presents it in the form of a card visualization.
5. Select Pin visual and pin this visualization to the Financial Sample dashboard.
6.Go back to Q&A and select Show all suggestions.
7.Select total profit by country.
8.Pin the map to the Financial Sample dashboard, too.
9. On the dashboard, select the map you just pinned. See how it opens Q&A again?
10. Place the cursor after by country in the Q&A box and type as bar. Power BI creates a bar chart with the results.
11.Pin the bar chart to your Financial Sample dashboard, too.
12.Select Exit Q&A to return to your dashboard, where you see the new tiles you created.
You see that even though you changed the map to a bar chart in Q&A, that tile remained a map because it was a map when you pinned it.
Step 4: Reposition tiles
We can rearrange the tiles to make better use of the dashboard space.
1. Drag the lower-right corner of the Gross Sales line chart tile upward, until it snaps at the same height as the Sales tile, then release it.
Now the two tiles are the same height.
2. Select More options (...) for the Average of COGS tile > Edit details.
3. In the Title box, type Average Cost of Goods Sold > Apply.
4. Rearrange the other visuals to fit together.
That looks better.
Clean up resources
Now that you've finished the tutorial, you can delete the dataset, report, and dashboard.
1.Select My workspace in the black Power BI header bar.
2. Select More options (...) next to the Financial Sample dataset > Delete.
You see a warning that All reports and dashboard tiles containing data from this dataset will also be deleted.
3. Select Delete.