This week has started with exploration of Power BI.
We had earlier downloaded Power BI Desktop (on-premise). Today we quickly created a report going against one of the cube in SSAS 2016.
Next logical question was how to deliver them to the users – SharePoint or SharePoint integrated SSRS?
We came across a separate Power BI Report server. Power BI Report Server is a solution that customers deploy on their own premises for creating, publishing, and managing reports, then delivering them to the right users in different ways, whether that’s viewing them in web browser, on their mobile device, or as an email in their in-box.
Came across this great page by Adam Saxton with great links:
Power BI Report Server offers a suite of products:
- A modern web portal you can view in any modern browser. In the web portal, you can organize and display reports and KPIs. You can also store Excel workbooks on the portal.
- Power BI reports, created with Power BI Desktop, that you can view within the web portal in your own environment.
- Paginated reports so you can create modern-looking reports, with tools for creating them.
- Mobile reports with a responsive layout that adapts to different devices and the different ways you hold them.
Read on for more about each.
What’s new in Power BI Report Server
These sources will keep you up-to-date on new features in Power BI Report Server.
For end users of Power BI Report Server, the front door is a modern web portal you can view in any modern browser. You can access all your reports and KPIs in the new portal.
You can apply your own custom branding to your web portal. And you can create KPIs right in the web portal. KPIs can surface key business metrics at a glance in the browser, without having to open a report.
The content on the web portal is organized by type: Power BI reports, mobile reports, paginated reports and KPIs, plus Excel workbooks, shared datasets, and shared data sources to use as building blocks for your reports. You can store and manage them securely here, in the traditional folder hierarchy. You can tag your favorites, and you can manage the content if you have that role.
And you can schedule report processing, access reports on demand, and subscribe to published reports in the new web portal.
More about the Web portal.
Power BI reports
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. Depending on your job role, you may be someone who creates reports and/or you may be someone who consumes or uses reports.
Reports are based on a single dataset. The visualizations in a report each represent a nugget of information. And the visualizations aren’t static; you can add and remove data, change visualization types, and apply filters and slicers as you dig into the data to discover insights and look for answers. Like a dashboard, but more-so, a report is highly interactive and highly customizable and the visualizations update as the underlying data changes.
Paginated reports are paginated document-style reports, in which the more data you have, the more rows in the tables, and the more pages the report would have. That’s great for generating fixed-layout, pixel-perfect documents optimized for printing, such as PDF and Word files.
You can create modern-looking reports using Report Builder or Report Designer in SQL Server Data Tools (SSDT).
Report Server programming features
Take advantage of Power BI Report Server programming features so you can extend and customize your reporting functionality, with APIs to integrate or extend data and report processing in custom applications.
More Report Server developer documentation.
Quickstart: Install Power BI Report Server
Install Report Builder