Which of the following is NOT a requirement for refreshing datasets from Azure SQL Database and SharePoint Online?

To understand the requirements for refreshing datasets from Azure SQL Database and SharePoint Online, it's essential to focus on what is necessary for such connections. A direct connection to Azure SQL Database can be accomplished without any additional gateways, as Azure SQL Database operates in the cloud and Power BI can connect directly to it.

Regarding SharePoint Online, it is also cloud-based, allowing for a direct connection through Power BI without an on-premises gateway. Since both Azure SQL Database and SharePoint Online do not rely on an on-premises data gateway for refreshing datasets, it is clear that this choice is not a requirement for refreshing data from these sources.

The personal gateway is designed for individuals who need to refresh datasets that are located on their local environments, but it is not required when dealing with cloud-based data sources. Diamond membership is not relevant to the operational requirements for dataset refreshing and pertains more to Power BI's licensing levels. Similarly, a direct connection is indeed a requirement, as both Azure SQL Database and SharePoint Online allow for it.

Thus, the understanding of these connections clarifies the role of the on-premises gateway, making it clear why it is not a requirement for refreshing datasets from Azure SQL Database and SharePoint Online.