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