Power BI Reports : A Beginner’s Guide to BI Reporting

2.7K Views
2 / 5 Blog from Reporting in Power BI

Become a Certified Professional

Today, the concept of Business Intelligence is alien to very few people. Newer, more interactive BI tools emerge every single day, appealing to a lot of organizations to help solve their crisis. In such a scenario, professionals who are certified in Microsoft’s Power BI prove to be golden, mainly because it is aimed to help everybody analyze and visualize their data. Even the non-technical Business people can use this tool to create interactive Power BI reports. This blog will be focused on Power BI Reports and would cover the following topics:

 What is a Power BI Report?

A Power BI report is a multi-perspective view into a dataset, with visualizations that represent different findings and insights from that dataset. A report can have a single visualization or pages full of visualizations. The visualizations in a report represent something like a dashboard does but serve a different purpose.

These visualizations aren’t static. In fact, far from it, with highly interactive & highly customizable visualizations which update, as the underlying data changes. You can add and remove data, change visualization types, and apply filters in your model to discover insights and look for answers.

Data Visualization - Power BI Reports - Edureka

How is a Report Different from a Dashboard?

So, the terms Report and Dashboard are used rather interchangeably but you can be assured they aren’t synonymous. The following table compares the features of a Report to those of a Dashboard.

CapabilityDashboardsReports
PagesOne pageOne or more pages
Data sourcesOne or more reports and data sets, per dashboardA single data set per report
Available in Power BI DesktopNoYes, can create and view reports in Desktop
PinningCan pin existing visualizations (tiles) only from the current dashboard to your other dashboardsCan pin visualizations (as tiles) to any of your dashboards. Can pin entire report pages to any of your dashboards.
SubscribeCan’t subscribe to a dashboardCan subscribe to report pages
FilteringCan’t filter or sliceMany different ways to filter, highlight, and slice
Set alertsNoYes
Modify/change visualization typeNo. In fact, if a report-owner changes the visualization type in the report, the pinned visualization on the dashboard does not updateYes

So basically, a report elaborates on a single dataset over many pages whereas a dashboard summarizes multiple datasets into a single page.

You can refer to this video curated by our Power BI Training expert for a more in-depth explanation.

What is a Power BI Report Server?

Power BI Report Server is an on-premises report server with a web portal in which you display and manage reports and KPIs, along with the tools to create Power BI reports, paginated reports, mobile reports, and KPIs.

It is like both SQL Server Reporting Services and the Power BI online service but in different ways. Like the Power BI service, Power BI Report Server hosts Power BI reports (.PBIX) and Excel files. Like Reporting Services, Power BI Report Server is on premises and hosts paginated reports (.RDL).  Your users can access those reports in different ways: viewing them in a web browser or mobile device, or as an email in their inbox.

Power BI Report Server is a superset of Reporting Services: everything you can do in Reporting Services, you can do with Power BI Report Server and more, with the addition of support for Power BI reports.

Learn Power BI from Industry Experts!

How is the Report Server different from the Service?

The Power BI Report Server has a lot in common with the Power BI Service but also a few dissimilarities. The table below explains it all.

FeaturesPower BI Report ServerPower BI Service
DeploymentOn-premises or hosted cloudCloud
Source dataCloud and/or on-premisesCloud and/or on-premises
LicensePower BI Premium or SQL Server EE with SAPower BI Pro and/or Power BI Premium
LifecycleModern lifecycle policyFully managed service
Release cycleOnce every 4 monthsOnce a month
Create Power BI reports in Power BI DesktopYesYes
Create Power BI reports in the browserNoYes
Gateway requiredNoYes for on-premises data sources
Real-time streamingNoYes
DashboardsNoYes
Distribute group of reports using appsNoYes
Content packsNoYes
Connect to services like SalesforceNoYes
Q&ANoYes
Quick insightsNoYes
Analyze in ExcelNoYes
Paginated reportsYesNo
Power BI mobile appsYesYes
ARC GIS mapsNoYes
Email subscriptions for Power BI reportNoYes
Email subscriptions for paginated reportsYesNo
Data alertsNoYes
Row-level securityOnly through data source in DirectQuery modeAvailable in both DirectQuery (data source) & Import mode
Full-screen modeNoYes
Advanced Office 365 collaborationNoYes
R visualsNoYes
Preview featuresNoYes
Custom visualsYesYes
Power BI DesktopVersion optimized for Report Server, available for download with Report ServerVersion optimized for Power BI Service, available from the Windows Store

How to Create a Report on Power BI?

Now there isn’t much use of the theory of Power BI if you’re not going to create reports on your own. Depending on your role, you may be someone who creates reports for your own use or to share with colleagues. Either way, you want to learn how to create and share reports or at least understand how to interact with reports.

There are many ways to create a report, and in this blog, we’ll start by creating a very basic report from an Excel dataset using Power BI service.

If you’ve already created Power BI reports in Power BI Desktop, then you’re almost ready to create Power BI reports for Power BI Report Server. I would recommend installing the version of Power BI Desktop optimized for Power BI Report Server, so you know the server and the app are always in sync. You can have both versions of Power BI Desktop on the same computer.

  • You can connect to a variety of data sources. From the welcome screen, select Get Data and import the files you want to.

Get Data - Power BI Reports - Edureka

  • Go to Data View and make the necessary changes in the data you’ve imported.

Data View - Power BI Reports - Edureka

  • Start designing your report.

Power BI Reports - Power BI Reports - Edureka

  • Once you think you’re done, go ahead and Publish the report to the Power BI site.

Publish Key - Power BI Reports - Edureka

Power BI Reports on the Mobile App

Power BI Reports now come in the convenience of your Mobile Apps. QR codes in Power BI can connect anything in the real world directly to related BI information – no navigation or search needed.

You can create a QR code in the Power BI service for any report, even for a report you can’t edit. Then you place the QR code in a key location. For example, you could paste it in an email, or print it out and paste it in a specific location.

Want to Master Power BI?

Creating a QR code

  1. On the rightmost top corner of your Dashboard in the Power BI website, you’ll see an ellipsis.
  2. Click on it and you will see an option saying Generate QR Code.
  3. Select that option and the QR code will be generated.
  4. Click on the download button to save the QR code.

QR code - Power BI Reports - Edureka

Colleagues you’ve shared the report with, can scan the QR code for access to the report, right from their mobile device. They can use either the QR code scanner located in the Power BI App or any other QR scanner installed on their device. They can also scan a report QR code with the Power BI for Mixed Reality App.

Tips and Tricks to create Powerful Reports on the Power BI

To get the most out of your data, sometimes you need a little extra help. So, here are some tips & tricks you can use when creating reports in the Microsoft Power BI Desktop.

Tip 1

Avoid visualization variety for the sake of variety. Visualizations should paint a picture and be easy to “read” and interpret. For some data and visualizations, a simple graphics visualization is enough. But other data may call for a more-complex visualization – be sure to make use of titles and labels and other customization to help the reader.

Tip 2

Be careful using charts that distort reality i.e. 3-D charts and charts that don’t start at zero. Keep in mind that it is more difficult for the human brain to interpret circular shapes. Pie charts, donut charts, gauges, and other circular chart types may look pretty, but perhaps there’s a different visual you can use instead?

Tip 3

Be sure to encode quantitative data nicely. Don’t exceed three or four numerals when displaying numbers. Display measures to one or two numerals left of the decimal point and scale for thousands or millions i.e. 3.4 million, not 3,400,000.

Tip 4

Try to avoid mixing levels of precision and time. Make sure that time frames are well understood. Don’t have one chart that has last month next to filtered charts from a specific month of the year.

Also try to avoid mixing big and small measures on the same scale, such as on a line or bar chart. For example, one measure can be in the millions and the other measure in the thousands. With such a large scale, it would be difficult to see the differences of the measure that is in the thousands. If you need to mix, choose a visualization, like a combo chart, that allows the use of a second axis.

Tip 5

Pay attention to how charts are sorted. If you want to draw attention to the highest or lowest number, sort by the measure. If you want people to be able to quickly find a particular category within many other categories, sort by the axis.

Tip 6

Pie charts are best if they have fewer than eight categories. Because you can’t compare the values side by side, it’s harder to compare values in a pie chart than in bar and column charts. Pie charts can be good for viewing part-to-whole relationships rather than for comparing the parts. And Gauge charts are great for displaying the current status in the context of a goal.

Tip 7

Sort by Another Column. When you use a categorical (string) value in Power BI for chart axes or in a slicer or filter, the default order is alphabetical. If you need to override this order, for example for things like days of the week or months, then you can tell Power BI Desktop to sort by a different column.

One key thing to remember: italics in the data grid do not mean the data type is correctly set, it just means the data is not considered as Text.

Tip 8

Power BI integrates with Bing to provide default map coordinates (a process called geocoding) so it’s easier for you to create maps. Bing uses some algorithms and hints to try to get the right location, but it’s the best guess. To increase the likelihood of correct geo-coding, you can do something like this. When you create a map, you’re often looking to plot countries, states, and cities. In Power BI Desktop, if you name columns after the geographic designation, it will help Bing guess what you’re looking to display.

For example, if you have a field of US state names such as “California” and “Washington”, Bing might return the location of Washington, DC instead of Washington State for the word “Washington”. Naming the column “State” will improve the geocoding. The same goes for columns named “Country” and “City”.

Want to learn this BI tool?

So, now that you know how to create reports on the Power BI, go ahead and create beautiful and impactful reports!

Comments
1 Comment

Browse Categories

Subscribe to our Newsletter, and get personalized recommendations.