Server Prerequisites

  • 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, 80 & 443

  • Local administrator account

  • PowerShell x86 and x64, set execution policy to RemoteSigned

SQL

The SQL Database must not be collocated on the Gizmo server, at the exception of “Proof of Value”.

  • SQL 2017 or 2019 Database - Standard, Enterprise or Azure SQL

  • User with db_owner access to create tables

  • SQL Authentication and Windows authentication supported

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

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