Server Prerequisites

Applies to on-premises

  • Minimum OS - Windows Server 2016

  • Minimum RAM - 8 GB (16 GB recommended if Power BI Desktop will import data from that server)

  • 4 Processors Minimum

  • 150 GB Drive Minimum

  • Windows Features Enabled

  • Internet Information Server (IIS)

  • .Net Framework 4.6.2 Full Minimum

  • Ports (inbound) TCP 5672/5671, 80/443

  • Local administrator account

  • PowerShell x86 and x64, set execution policy to RemoteSigned

SQL

  • SQL 2017 Database - Standard, Enterprise or Azure SQL

  • User with db_owner access to create tables

  • SQL Authentication (Windows authentication not supported)

  • Connection access to SQL database (port 1433 by default)

  • Optional, but suggested: SQL Management software, such as Azure Data Studio, or SSMS