How to build reports in Microsoft Power BI
Your email has been sent
Find out what you need to have Microsoft Power BI reports online for viewing within minutes.
According to Microsoft, Power BI reports are “…a multi-perspective view into a dataset, with visuals that represent different findings and insights from that dataset.” It’s another way of saying that a Power BI report is a chart or data visualization.
After creating a Power BI report, you can pin it to a dashboard for others to view. That’s what Microsoft Power BI does: It helps you create meaningful reports, AKA charts, and display them for others in your organization.
SEE: Best business intelligence tools 2022 (TechRepublic)
In this tutorial, I’ll provide step-by-step instructions for creating simple reports in Power BI Desktop; you can also create reports in Power BI service online. Power BI mobile apps don’t support report design. If you want to follow along using the same data, download the demonstration .xlsx file.
A Power BI report connects to a single dataset and will have at least one report page, but it can have many pages. In order to build reports in Power BI, the only thing you really need is data. I’ll use the simple Microsoft Excel dataset shown in Figure A.
Figure A
Thinking ahead, you’ll lay out report objects on a report page. Objects include visuals and elements.
On report pages, you’ll add visuals and elements. You can add, rename, re-sequence, hide, duplicate and delete pages. To select a page, users select the page in the Pages pane in the Power BI service. If you’re using Power BI Desktop, click a page tab.
First, sign into your Microsoft account and then launch Power BI. Next, you need data, and in Power BI you can import data from many sources, including Excel workbooks (Figure B).
Figure B
You can create the data in Power BI, but you’ll do so only when the data is missing or incomplete. In most organizations, you’ll find the source data in OneDrive or SharePoint. Importing from an Excel file saved to OneDrive is one of the easiest choices, so I saved my Excel file, PBIImportFromExcel_SourceFile.xlsx, to OneDrive. The data is in a Table named TableSales.
In Page 1, which Power BI opens when launched, click the Excel Workbook option in the Data group. Using the resulting Open dialog, locate the Excel file (Figure C), select it and click Open.
Figure C
The resulting Navigation pane allows you to choose Table objects or a sheet. Checking TableSales displays a sample of the data (Figure D). Click Load to import it into Power BI, which will create a connection to the data and load it into Power BI. You can start adding visuals based on the imported Excel data.
Figure D
Once you have a report page and data, you’re ready to add visuals to build a report. It’s important to select the best visual for your data and your story. There are a lot of visuals and selecting the best one for your data can be a challenge. Here are tips for choosing the ideal visuals in Power BI.
For our purposes, let’s create a bar and treemap visual. A bar is effective when you have a lot of data, and the treemap will provide a look at the overall sales picture by relating the values to one another.
We’re ready to create the first visualization, a clustered bar chart. If you’ve built charts in Excel or some other software, you’re a step ahead because this task requires specialized knowledge. If all else fails, drag and drop fields until you get it right — Power BI is very forgiving.
To create a bar visualization using our Excel data, do the following:
Figure E shows the resulting visualization after being resized. This visualization displays the sales figures for each region. The dates, although imported, are irrelevant. You could review format options, but to keep things simple, this one is good enough as is. Let’s move on to the treemap visual.
Figure E
A treemap visual compares values as a whole. We’ll use this highly effective visualization to compare monthly sales.
To base a treemap visual on our data, follow these steps.
Figure F shows the Treemap visual next to the clustered bar visual. As is, the treemap compares the monthly sales as a whole, and it’s easy to discern that January and March were great months.
Figure F
This time we’ll allow users to filter the visualization by regions. To do so, drag Region to the first Filter, the This Page control. Now Power BI displays the regions as a filtered set. Click the Select All option (Figure G) so initially the visualization will represent all regions.
Figure G
Let’s publish the visualizations so users can view them.
At this point, you have two visualizations on a report page. In order for users to view the report, you must publish it. To do so, click Publish in the Share group. Click Save if prompted. Use the Save As dialog to choose the location for saving the .pbix file. Give the file a name and click Save. Enter your email address within the organization and click Continue. This will sign you into your account if you didn’t do so earlier. Finally, choose a destination, which is My Workspace for now.
Power BI displays the link to the published report (Figure H) — click it to see the report shown in Figure I. Use the Filters pane to the right to filter the treemap visualization by region(s).
Figure H
Figure I
This simple Power BI report is just the beginning. Your business requirements will be the deciding factor as to whether your Power BI reports are simple or complex.
Learn the latest news and best practices about data science, big data analytics, artificial intelligence, data security, and more. Delivered Mondays and Thursdays
Learn the latest news and best practices about data science, big data analytics, artificial intelligence, data security, and more. Delivered Mondays and Thursdays
How to build reports in Microsoft Power BI
Your email has been sent
TechRepublic Premium content helps you solve your toughest IT issues and jump-start your career or next project.
This is a comprehensive list of the best AI art generators. Explore the advanced technology that transforms imagination into stunning artworks.
Find the perfect payroll service for your business without breaking the bank. Discover the top cheap payroll services, features, pricing and pros and cons.
Is NordVPN worth it? How much does it cost and is it safe to use? Read our NordVPN review to learn about pricing, features, security, and more.
Free project management software provides flexibility for managing projects without paying a cent. Check out our list of the top free project management tools.
Australian and New Zealand enterprises in the public cloud are facing pressure to optimize cloud strategies due to a growth in usage and expected future demand, including for artificial intelligence use cases.
The end of a year provides an ideal opportunity for revisiting the previous year’s goals and performance, reviewing personal and professional aspirations and prioritizing the upcoming year’s initiatives. But where to start? Tech pros can implement these seven planning steps from TechRepublic Premium to successfully set and track goals and subsequently prioritize initiatives. From the …
The role of a technical copywriter is recognized as a cornerstone in defining and conveying a company’s identity in the ever-evolving landscape of today’s business, where the online presence and narrative of a brand have outstanding value. This hiring kit from TechRepublic Premium provides an adjustable framework your business can use to find the right …
With artificial intelligence being more popular than free alcohol at a tech conference, it’s wise to stay informed about all things AI or even implement policies for its correct usage. This TechRepublic Premium pack provides readers with seven downloads for a bargain price. The bundle comprises two glossaries about AI and machine learning; three features …
A successful chief digital officer drives their organization’s digital transformation and creates value while rationalizing business processes and the customer experience. This hiring kit from TechRepublic Premium provides a workable framework you can use to find the best CDO for your organization. From the hiring kit: EDUCATION AND EXPERIENCE Candidates must have a degree in …
Get the web’s best business technology news, tutorials, reviews, trends, and analysis—in your inbox. Let’s start with the basics.
* – indicates required fields
Lost your password? Request a new password
Please enter your email adress. You will receive an email message with instructions on how to reset your password.
Check your email for a password reset link. If you didn’t receive an email don’t forgot to check your spam folder, otherwise contact support.
This will help us provide you with customized content.
Thanks for signing up! Keep an eye out for a confirmation email from our team. To ensure any newsletters you subscribed to hit your inbox, make sure to add [email protected] to your contacts list.
Leave a Reply