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.

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.

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.

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.

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.

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

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

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

Publish the Power BI Report

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

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

You may also like the below Power BI tutorials:

• Add Title, Image, and Video to Power BI Dashboard
• Access to the resource is forbidden error in Power BI
• Power BI: Create a various report from SharePoint Online list
• PowerBI Report Filter using Slicer Visualization
• Built-in Date Hierarchy in Power BI
• Power Bi relative date slicer
• Power BI Visualizations
• Power BI Custom Visuals
• Microsoft Power BI Error: This content isn’t available
• Power BI On-premises Data Gateway
• Power BI Error: This content isn’t available
• Power BI Workbooks
• Power BI Buttons
• How to Split Columns in Power BI

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.