PowerBi Tidbit - Using PowerBi on-prem

  • Article

Hello All,

As you may or may not know the cloud has had PowerBi for a while now and it has been a great success at data visualization creating powerful dashboards and helping people make informed decisions every day.

And now we have PowerBi moving on-prem with the PowerBi Report Server your users will be able to create, publish, and distribute beautiful reports quickly using this tool, as well since Power BI Report Server is part of Power BI Premium you are cloud ready for when you want to move to the cloud.

Installing, what do you need to know?

  1. Requirements to install Report Server
    1. .NET Framework 4.6
    2. 1GB free space for installation files, Additional space for Databases on hosting server
    3. Recommend at least 4GB RAM
    4. Recommend 2.0 GHz or faster processor
    5. Installation  account must be in local administrator group
    6. Processor types: x64 Processor: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support
    7. Operating Systems: Windows Server 2016 Datacenter, Windows Server 2016 Standard, Windows Server 2012 R2 Datacenter, Windows Server 2012 R2 Standard, Windows Server 2012 R2 Essentials, Windows Server 2012 R2 Foundation, Windows Server 2012 Datacenter, Windows Server 2012 Standard, Windows Server 2012 Essentials, Windows Server 2012 Foundation, Windows 10 Home, Windows 10 Professional, Windows 10 Enterprise, Windows 8.1, Windows 8.1 Pro, Windows 8.1 Enterprise, Windows 8, Windows 8 Pro, Windows 8 Enterprise
  2. Requirements for Report Server Database Server
    1. Supported versions of SQL: SQL Server 2017, SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, SQL Server 2008
    2. Can be local or remote, if remote you need to configure Connection with properly permissioned domain account (See here for more info)

Configuration, what do we do now?

  1. The account used for Reporting Services Configuration Manager needs server roles Public and DbCreator.
  2. You must be able to setup a Port 80 website with Virtual directory names ReportServer and Reports
  3. While you can have Read-Only DC’s the service does need access to a Read-Write DC
  4. Connection  to analyze service can be live, and must be one of the following version and Sku
Server version Required SKU
2012 SP1 CU4 or later Business Intelligence and Enterprise SKU
2014 Business Intelligence and Enterprise SKU
2016 and later Standard SKU or higher

Finally ready to install and configure , so what am I doing?

  1. Go online and look under PowerBi Premuim and you will find the link PowerBI Report Server Key or Volume Licensing if you have SQL Server Enterprise SA
  2. Download the PowerBi Report Server bits from here
  3. Click thru the wizard to install the service
  4. Click to configure reporting server, this will initiate the creation of your database.  If using a remote SQL server then follow these instructions to configure the connection string

To get more information about install and config see here

I want more information where can I go:

Pax