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

[KrithikaBaskar1]

Hi,

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

Is that possible and how?

Thanks,

Krithika

[v-yangliu-msft]

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.

[RJ251997]

Hi @KrithikaBaskar1 ,

• The SQL Server instance that hosts your database is NOT installed on your machine
• You installed the Power BI Personal Gateway on that computer
• Remember, you don’t actually have to install the Gateway on the same machine which runs the SQL Server instance
• You sign in to your Power BI account
• You upload the pbix file you developed in Power BI Designer earlier
• After the file successfully uploaded go to datasets
• Click on the ellipsis button and click on “SCHEDULE REFRESH”

Now you can setup the schedule then click Apply. If you want more than one refresh just click on “Add another time”

Thank & Regards

Rohit Jaiswal