Power BI - Generating Reports



Create a Report in a Power BI Service

Making reports in a Power BI service is similar to report generation in a Power BI desktop. Before creating the report, you must either upload the file or construct the table. The various options like Paginated Report, create a report, and auto-generate report are facilitated in the Power BI service.

Auto Create Report

Richard is not familiar with the Power BI service; the first time he is trying to develop a new report. He logged in to the Power BI service and clicked on "Create" from the left pane and selected "Paste or manually enter data".

Case Study Auto Create Report

Richard entered the data manually and selected the "Use first row as headers" and clicked on the "Auto-create report".

Case Study Auto Create Report 1

The prompt "Your report is ready" will appear. He can click on the "View report now".

Case Study Auto Create Report 2

Finally, the stunning report is automatically generated. Richard can also navigate between these charts on a single report. For example, He gets to know the designation and work satisfaction of "Daniel".

Case Study Auto Create Report 3

Once he clicks on "Daniel", his designation and work satisfaction are populated on the report. By observing the screenshot, Daniel was designated as a senior manager and work satisfaction is "Very Good". Similarly, he can identify the work satisfaction and designation of other employees.

Case Study Auto Create Report 4

How to Create a Report from Scratch?

Richard got to know how to quickly summarize the data by utilizing auto-generating reports. Now, he wants to create a report from scratch. Click on the "My workspace" and select the "Create report".

Create a Report from Scratch

Create a Report from Scratch 1

Add Fields to Report

He can select the "Stacked bar chart" visual and add the Designation field to the Y-axis and the "Work Satisfaction" field to the X-axis. Therefore, the stacked bar chart shows the count of work satisfaction by the employees designation.

Add Fields to Report

Now, he can save this report and share it with colleagues within the current organization.

Q&A in Power BI Service

You can choose the Q&A visual to ask questions and get to know about the dataset.

Q A in Power BI Service

Following are the sample questions that you can get the answers in the Q&A visual.

Question 1 - Sort Table by Name

Once you write the question in the Q&A textbox, the sorted table by name is displayed on the canvas.

Sort Table by Name

Question 2 - The Number of Software Engineer

The Number of Software Engineer

Question 3 - Create a Stacked column chart count designation by work satisfaction.

When you enter this question in the "Q&A" textbox, the stacked column chart will be populated on the canvas.

Create a Stacked column

Question 4 - Display which names have "Excellent" work satisfaction.

You can observe in the screenshot, that the name of the employees are populated on the screen.

Display which names have Excellent

Question 5 - Display Good (work satisfaction) with their names and designations.

As you would observe in the screenshot, the name, designation, and work satisfaction of those employees populated whose work satisfaction is "good".

Display Good Work Satisfaction

Publishing Report from Power BI Desktop in Power BI Service

Designers work on the Power BI desktop where they can create eye-catching beautiful reports. If you want to share reports with other teams within organizations. Firstly, open the Power BI Desktop and load the sample dataset from the local system. Assume that the sample report as you can notice in the screenshot.

Power BI Desktop in Power BI Service

Save the report before clicking on the "Publish".

Power BI Desktop in Power BI Service 1

The prompt of Privacy levels is displayed, read it carefully tick on the checkbox, and click on Save.

Power BI Desktop in Power BI Service 2

You can enter the valid email ID and click on the Continue.

Power BI Desktop in Power BI Service 3

Another dialog box will open where you can write your official email ID and click on Next.

Power BI Desktop in Power BI Service 4

Enter a valid password to Sign in to your Microsoft account. If you forgot your password, then click on the "Forgot my password" to reset your password again. You may encounter difficulties in signing if your username and password are incorrect.

Power BI Desktop in Power BI Service 5

You can click on the OK in the "Stay signed in to all your apps" dialog box.

Power BI Desktop in Power BI Service 6

The prompt will appear that shows the message "Publishing to Power BI" which takes a few seconds for further messages.

Power BI Desktop in Power BI Service 7

As you can observe in the screenshot, the report has been published to the Power BI service. Now, you can swiftly take a close-up of the report in the Power BI service and get Quick Insights into it. Click on the link Open employye1234.pbix in Power BI.

Power BI Desktop in Power BI Service 8

And finally, the report is shown in the Power BI service.

Power BI Desktop in Power BI Service 9

Click on "My Workspace" where you can observe that the report and semantic model of "employye1234" are saved in this respective location.

Power BI Desktop in Power BI Service 10
Advertisements