On-premises data gateway planning

Planning for the On-premises data gateway involves considerations for infrastructure/resources and networking, data governance, and the administration of the gateway itself. Before committing to a gateway, an organization can determine if BI solutions should be developed against data sources that require a gateway such as legacy on-premises databases or if this data should be loaded/centralized in a source that doesn’t require a gateway such as Azure Synapse or Azure SQL Database.

For example, a BI team could determine that a gateway will only be used for a particular on-premises SQL Server database and any other on-premises sources such as files on network file shares and other databases will either not be supported or will require its own gateway in the future.

After determining that a gateway or cluster of gateways will indeed be a required component of the Power BI architecture, more detailed considerations can be reviewed such...