Power BI Report Server

What is Power BI Report Server?

Power BI Report Server is known as on-premises report generating worker that is utilized to have or generate Power BI reports. The dashboards or reports facilitated on the on-premises report worker are shown to the clients through an online interface. You can likewise have paginated reports, portable reports, and KPIs on the report worker since it is based upon Structured Query Language Server Reporting Service's design. You can access and view every one of the sorts of reports on report worker utilizing an internet browser, cell phone or by means of email.

There are many benefits of utilizing an on-premises report worker to have Power BI reports. It is viable with the service of Power BI and you can without much of a stretch incorporate it with your current Reporting Services. Likewise, on-premises report worker is liked by numerous associations according to a security perspective. Associations think that it is more secure to have significant reports on a protected on-premises arrangement instead of on the internet cloud.

As we probably are aware, Power BI as an innovation is an assortment of a few different advances and administrations. Power BI Report Server is one such pivotal innovation. Here, we will find out with regards to its various viewpoints:

1. Installation
2. Basic Features
3. Features of Latest Version
4. Working/architecture.
5. Components

Installation process of Power BI Report Server is shown in following steps.

The below mentioned System Requirements are mandatory to support working with power bi.

Platforms: The following platforms are compatible with power bi – Windows 8.1 or Windows Server 2012 or Windows 10 or Windows 8 or or Windows Server R2/Windows Server 2016.

Frameworks (that are compatible with power bi): .NET Framework (version 4.5.2 or later).

Preferred Database (compatible with power bi): Structured Query Language (SQL) Server Database Engine (2008). This is for preserving the report generated.

SQL (Structured Query Language) Server Analysis Services It is required for Live Analysis generating report in Services data sources.

Stage 1: peruse to the Microsoft Download Center, then, at that point hit on the Red Download button as displayed.

Stage 2: Select the download document and push on Next.

Stage 3: The introduce wizard will begin. Press on Install Power BI Report Server.

Stage 4: Next, pick the version you wish to introduce. You will get a free version and a top notch release.

For the superior release, you need to enter an item key. You can track down the exceptional item key from the settings of Power BI Premium.

Additionally, there are two sorts of free release; Evaluation (lapses in 180 days approx) and Developer.

Stage 5: The following window will show the permit terms. Investigate, check the "I acknowledge the permit terms" and push on Next.

Stage 6: You will require a case of the SQL Server Database Engine. Press the radio catch for "Introduce Power BI Report Server as it were" and press Next.

Stage 7: Next, indicate the introduce area and press on Install. The way is C:\Program Files\Microsoft Power BI Report Server.

Stage 8: Press on Configure once your arrangement is finished.

Power BI Report Server Features

As we probably are aware, report worker operates on SQL SERVICE REPORTING SERVICE(SSRS) system thus we can consider it a subset of SQL SERVICE REPORTING SERVICE(SSRS). Being a subset, it has some critical provisions and a significant job to carry out. We have examined some critical elements beneath:

• The report worker has Power BI reports on-premises. One can share reports and team up with different clients by utilizing the on-premises report worker. Additionally, it has the novel capacity to send and utilize portable reports, paginated reports.

• It can deliver custom perceptions. Clients facilitating their Power BI reports on this on-premises worker gets an additional 100 custom visuals to the default ones.

• Users can associate with the this from Power BI Mobile. They can get to reports from the report worker without any problem. As of now, the report worker is upheld by iOS, Android, Windows versatile stages.

• From the on-premises report worker, clients can get to and associate with gives an account of a web stage. They can utilize and apply activities like cross-separating, tooltips, slicers, information investigation, and so forth

• Users can send out information from reports facilitated on a Report Server to a CSV design record.

Latest Features of Power BI Report Server –recent updates (or new version) of January 2019

The most recent variant of the report worker is the January 2019 update. We have recorded a couple of good and new provisions of its most recent form here:

1. Improves report openness
2. Row-level security
3. Scatter outlines supporting speck plot design
4. Better console alternate routes discourse
5. Helps in further developing DAX editorial manager
6. Built-in report subjects
7. Improve displaying openness
8. Filter cards in search
9. New transport layer security settings

Elements like growing and imploding lattice column headers, duplicate qualities and choices from table and grid, set tab request, the tooltip for button visuals, and so forth are likewise also added.

Power BI Report Server Architecture

View the work process flow outline underneath to comprehend the design and working of report worker better.

The report creators work on Power BI composing instruments like Power BI Desktop to make reports. The reports are created utilizing information from information sources accessible to interface with Power BI. When the reports are prepared, you then, at that point go to the Report Server. The worker has the reports and its web-based interface is shown. Clients can burn-through the reports facilitated on the report worker by means of the online interface. They can utilize the web-based interface from any gadget that upholds it like a work area, PC, tablets, and telephones.

Parts of Power BI Report Server (Components)

There are a few significant parts identified with the report worker. Peruse exhaustively about them in the areas beneath:

1. Web-based interface

The web-based interface is to show reports that are facilitated on the Power BI Report Server. You can get to the online interface from any most recent program. The online interface has every one of the reports and KPIs stacked on to the report worker. You can play out a few exercises utilizing the online interface, for example, on-request report access, take a membership for distributed reports, apply custom brandings to the web-based interface, and timetable report preparing. There is shifted content on the web-based interface, for example, Power BI reports, portable reports, paginated reports, KPIs and Excel exercise manuals. These distinctive report types are masterminded in a similar request in a conventional envelope chain of importance. Reports are gathered by report types as referenced before. You can likewise get to shared datasets and shared information sources through isolated organizers in the entryway.

2. Power BI analytic Reports

The main piece of the whole idea is the Power BI reports. Power BI reports are not single-paged instead they are multi-paged instructive document addressing an information model via representations. Power BI Desktop has heaps of representation types which you can use to make the report. We can maintain as no. of pages in a power bi report with as numerous representations, you need to utilize.

You can make reports on a Power BI Desktop (upgraded for report worker). Later you can distribute these reports on the online interface for others to display and utilize. Business clients and different sorts of clients can separate fundamental information and bits of knowledge from these reports.

There are two additional sorts of reports facilitated in the report worker and they are:

a. Mobile Reports

One more kind of reports that the worker has and shares on its web-based interface are the versatile reports. These resemble Power BI Reports yet versatile to the screen of the cell phone you are seeing them on.

b. Paginated Reports

1. A paginated report is a coordinated, archive style page to page report. The augmentation utilized for a paginated document is RDL.
2. Paginated reports are saved as paged archives where you can extend the record upward and on a level plane to see the total information.
3. Such reports are pixel-wonderful with a proper format.
4. They can be the most ideal choices when you need to take copy of a report, in the form of PDF or Word document.