Create a Report using Excel Data in Power BI Workspace

How to create a report using Excel Data in Power BI Workspace with a practical example?. It is the Excel Workbook that we imported in our previous article.

Before we start creating a report using the excel file, let me show you the dataset in my Power BI workspace. To view the same, please click on the Power BI My Workspace, and then go to the Datasets tab. In this example, we use that Global Store excel dataset and I suggest you refer to the Upload Excel file article.

Create a Report using Excel Data in Power BI Workspace 1

How to create a Report using Excel Data in Power BI Workspace

Click on the Chart (or Visual) button beside the Excel Dataset

Create a Report using Excel Data in Power BI Workspace 2

Please wait until the data is loaded

Create a Report using Excel Data in Power BI Workspace 3

Clicking the Create button opens the following window. Here, you can create your own visuals.

Create a Report using Excel Data in Power BI Workspace 4

For the demonstration purpose, we created a Clustered Column Chart.

Create a Report using Excel Data in Power BI Workspace 5

Let me do some quick formatting to Clustered Column Chart. Once you finished creating a report, click on the Save button

Create a Report using Excel Data in Power BI Workspace 6

Clicking the Save button opens a Save Your report window. Please provide the report name.

Create a Report using Excel Data in Power BI Workspace 7

Within the Reports tab, you can see the report that we created.

Create a Report using Excel Data in Power BI Workspace 8