Power BI provides two types of gateways : On-premises data gateway and Power BI Data Gateway – Personal mode

* On-premises data gateway : The On-premises data gateway is used to connect Power BI to on-premises data sources like SQL Server, SharePoint, File Share, or other data sources residing within an organization’s network. It acts as a bridge between the cloud-based Power BI service and the on-premises data, allowing secure data transfer without exposing the data source directly to the internet.

* Use Cases : You should use the On-premises data gateway when you have data stored in on-premises databases or files, and you want to create reports and dashboards in Power BI that use this data. It enables you to keep the data within your organization’s network while still benefiting from the cloud-based visualization and collaboration capabilities of Power BI.

* Power BI Data Gateway – Personal mode : The Power BI Data Gateway – Personal mode (formerly known as the Power BI Personal Gateway) is designed for individual use or small-scale scenarios. It allows you to refresh data in Power BI datasets from data sources that require credentials, such as Excel files, SQL Server databases, or other supported sources.

* Use Cases : You should use the Power BI Data Gateway – Personal mode when you need to refresh data in a dataset stored in the Power BI service, and the data source requires credentials for access. It is useful for personal or small-team use cases where you don’t need the central management features provided by the On-premises data gateway.