Data comes from sql (on-premises) and need to schedule a refresh using data gateway in cloud(azure).

Hi  KrithikaBaskar1  ,

In power bi, you can only use power bi gateway to set up scheduled refresh. If your sqlserver is in the cloud, you can refresh without a gateway. If it is a local database, you need power bi gateway to perform scheduled refresh.

This is the relevant document, hope to help you:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.