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

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