Force SQL Azure to use BI Gateway

[cittakaro]

Hi All, 

Do you know how to force Azure SQL connection to use BI Gateway with data source pointing to Azure SQL? 

The reason is I only want allow one IP address to Azure, which is IP address of Power BI Gateway Server.

Thanks.

Iwan

[Anonymous]

@cittakaro,

If your dataset only contains Azure SQL database, no gateway is required to refresh the dataset in Power BI Service, and it is not possible to force the dataset to use gateway.

Regards,
Lydia