Create a Report using Excel Data in Power BI Workspace

In this article, we will show you, How to create a report using Excel Data in Power BI Workspace with practical example. This is the Excel Workbook that we imported in our previous article. I suggest you to refer Upload Excel Files article

Before we start creating a report, 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 will use that Global Store excel dataset

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

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

Please wait until the data is loaded

Clicking the Create button will open the following window. Here, you can create your own visual.

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

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

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

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