Thought I’d post my initial impressions of installing Power BI Report Server. Unless you’ve been disconnected from the web for any length of time, you’ve heard of Power BI. In May 2017, Microsoft released the Power BI Premium service tier, which includes the Power BI Report Server.
The home page will remind you of SSRS:
You have the option to install PBI Report Server as standalone service, or on the same server with SQL Server and/or SQL Server Reporting Services. In any event, you need to install PBI Report Server on a server running a SQL Server instance.
If you are familiar with the Power BI desktop software, there is a new PBI Desktop software you’ll need to install to work with PBI Report Server.
Here are the details and link:
Microsoft Power BI Report Server – June 2017 GA
Power BI Report Server, available as part of Power BI Premium, enables on-premises web and mobile viewing of Power BI reports, plus the enterprise reporting capabilities of SQL Server Reporting Services.
In this version of Power BI Report Server, you can:
- Connect “live” to Analysis Services models – both Tabular and Multidimensional (cubes)
- Visually explore data and create an interactive report
- Use custom visuals in your Power BI Report
- Save that report to your report server running the preview
- View and interact with the report in your web browser
- Add and view comments about the report in the web browser
- View and interact with the report in the Power BI Mobile App
Let’s walk though an install of Power BI Report Server
Run PowerBIReportServer.exe, select install PBI Report Server
Choose evaluation version, unless you have the product key, click Next
Agree to license terms, click Next
You’re installing on a server with the database engine installed, click Next
Next up, configure report Server.
Connect to your local SQL Server instance
Note that once connected, your instance will be:
Next, click the Web Service URL on left and change name of VirtualDirectory to: ReportServerPBI (this allows SSRS to co-exist). Click Apply.
Click database, on left
Click Test Connection to validate. If everything is fine, connection succeeded
Add a PBI suffix to the Database name (so it doesn’t over-write SSRS)
Use default service credentials, click next
Review summary, click next
Click Web Portal URL on left, then add PBI suffix to Virtual Directory name, click Apply
Click the hyperlink shown the last dialog and it should take you to the Power BI Server.
Watch this blog for future updates on using the PBI Server and the new PBI Desktop software.