Need help understanding the building blocks that make up Power BI Preview? See Power BI Preview - Basic Concepts.
Note: This article is about the new Power BI Preview experience, and not about Power BI for Office 365. Read more about which Power BI experience is right for me.
Prefer to watch instead of read? Watch our getting started video:
Step 1: Get data
Sign in to Power BI. Don't have an account? You can try out the new Power BI Preview for free.
If you have important data in an Excel spreadsheet on your computer, you can create a Power BI dashboard to stay informed anywhere and share with others. Are you a Salesforce user? Get a head start by connecting to Salesforce to automatically create a dashboard from that data.
- Select Files.
Want to continue this tutorial with sample data? Download this sample Excel spreadsheet. - Select Local File, browse to the file on your computer, and choose Open.
- Power BI uploads the Excel file and displays the new dashboard. In the left navigation pane, the new dashboard is listed under the Dashboards heading and the new dataset appears under the Datasets heading. The yellow asterisk indicates the dataset is new.
Step 2: Explore your dataset
Now that you have connected to data, explore to find insights. When you've found something you want to monitor, you can create a dashboard to keep up-to-date with changes.
- Click the dataset image on the dashboard to explore the data you just connected to.
- Click Got it to close the tip about creating your first chart.
- In the Fields list on the right side of the page, select fields to build a visualization. Click the checkbox beside Gross Sales and then Date.
- Click the change visualization type button
to switch to a different way of displaying your data. Try changing to a line chart by clicking the line chart option.
- When you have a visualization you want on your dashboard, select the visualization and click the Pin button. When you pin a visualization, it will be stored on your dashboard so you can track the latest value at a glance.
- Because this is a new report, you need to save it before you can pin a visualization from it to the dashboard, as a tile.
- Give your report a name and click Save. Power BI pins the visualization at the same time.
- Click the Power BI button
in the top-left corner of your browser window to go back to your dashboard.
- Back on your dashboard, you can see your new visualization. Make your dashboard look even better by renaming, resizing, and repositioning tiles.
You can click the new tile on your dashboard to go back to the report anytime. - For a quick exploration of your data, try asking a question in the Q&A box. For example, try typing "what segment had the most revenue".
- Click the pin icon
to show this visualization on your dashboard too.
- Click the back arrow
to go back to your dashboard.
