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,

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.

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)

Select Excel Workbook as a data source for this 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.

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

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.

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

Let say Clustered Column chart.

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.

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.

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.

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.

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

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.