Getting Started With First Microsoft Power BI Report

To start with Power BI Report, you need to download Power BI Desktop App from the Link.

Once it gets downloaded open Power BI Desktop application which will look like this,

Getting Started with First Microsoft Power BI Report

There are many ways to Import data for Power BI report like Import data from Excel, Import Data from SQL Server, and many more.

For this article, we will use Import Data from Excel method for our Power BI Report.

Create a sample Excel for Power BI which will act as a Data Source for Power BI.

Getting Started with First Microsoft Power BI Report

Once we create Excel successfully as shown above, we will use this Excel as a Data Source in Power BI Desktop app.

The next step is to open Power BI Desktop application and click on Get Data which is present on Top of the Menu bar (Highlighted below in Yellow)

Getting Started with First Microsoft Power BI Report

Select Excel Workbook as a data source for this Report.

Getting Started with First Microsoft Power BI Report

Now it will ask your Excel Location which you have created in your system as a sample data source for your Power BI report.

Getting Started with First Microsoft Power BI Report

After selecting the Excel file, select the Sheet which will populate data in the Report (Shown below)

Getting Started with First Microsoft Power BI Report

Click on Load.

Once it is loaded and applying changes to the Sheet you can now see Data of your Excel in Data tab of the Power BI app.

Other side you can see visualizations panel and Fields panel

Fields panel will define the Column in the Sheet.

Getting Started with First Microsoft Power BI Report

Next step is to select one of the visuals from the visualizations section.

Getting Started with First Microsoft Power BI Report

Let say Clustered Column chart.

Getting Started with First Microsoft Power BI Report

Now you must select or drag and drop column fields that you want to populate on this above visual like mentioned in the below figure.

Getting Started with First Microsoft Power BI Report

That’s the way you can create a report very quickly.

You can also see the tooltip applied to this report in the below picture.

Getting Started with First Microsoft Power BI Report

When the report is ready you can publish the report by clicking on publish button present in the Menu bar mentioned in the pic below.

Getting Started with First Microsoft Power BI Report

All you have to provide is the Report Name, Account Username, and password of your https://app.powerbi.com/ account and Select workspace in which you want to publish your report.

Getting Started with First Microsoft Power BI Report

Once you successfully published the Report will look like this online.

Getting Started with First Microsoft Power BI Report

Summary

This is how you can create a sample data in Excel workbook and by using that excel workbook you can create a Microsoft Power BI report quickly.