how to schedule refresh for the dataset using on-prem sql database with option 'Import'

shanjaf First, you will need to make sure you have a gateway set up. You can do either Personal or Enterprise, choose the fit that works best for your purpose.

Personal: https://powerbi.microsoft.com/en-us/documentation/powerbi-personal-gateway/

Enterprise: https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise/

And this will walk you through how to set up the refresh:

https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-desktop-file-local-drive/

Be aware, there is currently a 250mb limit on the size of the Power BI Desktop file. So any file that is larger than this will not be able to be pushed to the Service.