Create a Power BI report from Excel using Power BI Desktop

This Power BI tutorial explains, how to create a report using the Power BI desktop. Before knowing about Power BI desktop I will say what is Microsoft Power BI?

What is Power BI?

Power BI is a cloud-based free tool provided by Microsoft to visualize our data interactively. We can share the data with others within our environment. We can also embed the Power BI in our application.

What is the Power BI Desktop?

Microsoft Provides a platform for Power BI we can create different dashboards and reports from the different data sources. The Power BI desktop is the free open source that we can freely install in our local system.

Create a report using Power BI desktop from Excel Datasheet

Follow the below steps to create a Power BI report using the Excel data.

At first, I have created an Excel sheet in my local system. You can see my Excel sheet in the below screenshot.

power bi create excel report
power bi create excel report

Before creating the Power BI Report, You have to install the Power BI in your local system/desktop. Open this Power BI desktop from your system. Click on Get Data from the ribbon and select the Excel option as shown below.

create report in power bi
create report in power bi

Once you will click on Excel, a Navigator page will come where you need to select the table name which you are created before using the excel sheet. Then click on the Load.

connect excel to power bi
connect excel to power bi

From the Visualizations option, list chooses one in which you want to display your data. From the Fields option, Choose all the field names which data you want to display in the visualization.

connect excel to power bi
connect excel to power bi

In the PowerBi desktop screen left side, we can see 3 tabs.

Report: The report tab will display the data visualization with the selected shape.

connect excel to power bi
connect excel to power bi

Data: The Data tab is displaying all the data which we have created in Excel.

create report in power bi
create report in power bi

Model: In the Model, Tab will look like below.

create report in power bi
create report in power bi

We can create a Duplicate page from the below of the page in the report tab. We can rename our page also.

power bi excel tutorial
powerbi create duplicate pages

Publish the Power BI Report

After creating the Power BI report, we can publish the Power BI report.

power bi create excel report
power bi create excel report

After our report publishing successfully we will get the below message.

create power bi report from excel
publish power bi report

You may also like the below Power BI tutorials:

In the Power BI article, we were discussed how to create a report using excel data source. And how to publish our report to the workspace in Power BI.

>