On-premise data SQL Server and smartsheet

Hi knpbi,

I am not familiar with smartsheet. Based on my research, smartsheet is an online service application which is used for collaboration and work management.

Currently, when you combine on-premises SQL Server data source and online data source in a dataset, you are not able to use on-premises gateway to schedule refresh for the dataset, this is a known issue that has been submitted in the following link and the feature using on-premises gateway to work with online data sources is under review, please vote it. The current workaround  is to use the personal gateway to schedule refresh for your dataset.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13405644-combine-enterprise-gateway-and-online-data-sources

Thanks,
Lydia Zhang