Install The Power BI Gateway
A Microsoft Power BI date gateway an app that you install in on an on-premises device. The on-premises data gateway acts as a bridge to provide quick and secure data transfer between the ConfigMgr SQL database and the Power BI service. There are two data gateway types; personal and standard. Only the standard gateway is supported by BI for SCCM. Most customers install the gateway on the ConfigMgr primary site server or the CAS. .NET Framework 4.8 is required for the gateway. If .NET Framework 4.8 is not already installed a reboot is required to install it. If .NET Framework 4.8 is installed no reboot is required when installing the gateway. The gateway is available from Microsoft here. It is very important to keep the gateway app updated, a new version is released each month and there is no way to configure it to auto update. Many customers experience data synchronization failures due to not updating the gateway, for this reason we recommend updating the gateway app at least every 3 months.
Pre-requisites: The gateway communicates on the following outbound ports: TCP 443, 5671, 5672, and from 9350 through 9354. The gateway doesn’t require inbound ports. For a detailed list of URL’s, ports, and IP’s that need to be allowed please see this Microsoft Article.