Power BI On Premises – Power BI Report Server!
A few days ago Microsoft released a different version of licensing for Power BI. I will not move mostly on this, but it seemed an interesting introduction to the suite because it adds a component that many have been waiting for: the ability to perform deployment of BI reports as Power On Premises. Since it is a new component, I set out to investigate about their benefits and requirements.
For this, I plucked a laboratory and create a virtual machine on which I installed Windows Server 2016 (was pending also try this new OS Server from Microsoft version). Once I installed the OS Server launch the installation of SQL. For this also set out to install the latest, and went for SQL vNext CTP2.1 fresh out (is SQL 2017?). The installation is very friendly, and is not of major complications.
A point to consider when installing SQL Server is that it is convenient to install the whole package, I mean add components such as SSAS, SSRS, SQL Data Tools. Several points to note regarding the previous paragraph: SQL Server Analysis Services will be necessary and remember that for now Power BI Report Server only allows data source Live Queries against SSAS multidimensional models.
For SQL Reporting Services it is who will provide us with a platform (Portal) where we will stay our Power BI reports.
Installing Power BI Report Server
Now, once we fulfill these prerequisites had to installation details:
1. Download the PowerBIReportServer.exe file and run the installer. Download page:
2. Select the option to install Power BI Report Server.
3. Select the edition to be installed:
4. Read the terms and conditions and go ahead with the Next option.
5. Note that in this next step warns that an instance of SQL Server engine will be necessary to accommodate BD for our Report Server.
6. We specify below the location of our facility.
7. Once we finish with the installation, select the option Configure Report Server.
8. Our Setup screen Report Server is as the following screen:
9. Remarkable in this setup screen, generate the Service Account (recommended to use Network Service), and configuration WebService URL, and then the WebPortal URL. Remember at each point to hit Apply in every step.
Desktop Power BI Server Edition Report
After these steps, we will be able to set up our first report and finally post it on our own Power BI Report Server. Recall that this is critical to unburden a version of Power BI Desktop defined specifically to work with Report Server. This version is known as Power BI Desktop (Report Server) – not the same as we always work until now!!!
After we installed Report Server Desktop Power BI proceed to initiate such application, as in other reports Power BI start with the option to Get Data. We return to mention at this point that to publish in Report Server can only work today with SSAS sources, so we have a bucket on our server or SSAS Azure Service.
Once we generated we can publish our report in Report Server. For this we will see in Power BI Desktop Publish an option in Power BI Report Server:
Finally, as we installed Power BI Report Server and hosted on our own server, simply navigate with Edge or Internet Explorer to the Home page of our Portal Report Server. In my case will be: http: // pbipremium / Reports
To view the report simply we click on it, and this will allow us to see the full screen on the browser that report:
This new component of the Power BI suite opens up an important range of options when publishing reports on our own server, and upload to the cloud as you analyze where the organization is akin to that publication.
Another theme will be the subject of licensing, which has been discussed largely in the community and in Microsoft surely continue to work to give us options when making such facilities.
Looking for the next article about Power BI Premium!!!! See you soon!