Forum Discussion
Import data from web
elijah2018 The Desktop is your workhorse. This aspect of the tool allows you to do all your ETL and modeling. You publish this to the Service where you share. While the front end report building experiance is shared between the two parts of the tool, the Service is much more the "Sharing" part of the tool and you are limited in what you can do. There are only a few connections you could make from the Service, and you would be really limited if you tried to build everything on it.
The gateway connects the Desktop file to on-premises data sources to refresh what you publish. It doesn't create datasets on its own. The only reason you have to do it in this instance is you are likely using web.contents and they've mandated it with that connection likely due to security.
elijah2018 The Desktop is your workhorse. This aspect of the tool allows you to do all your ETL and modeling. You publish this to the Service where you share. While the front end report building experiance is shared between the two parts of the tool, the Service is much more the "Sharing" part of the tool and you are limited in what you can do. There are only a few connections you could make from the Service, and you would be really limited if you tried to build everything on it.
The gateway connects the Desktop file to on-premises data sources to refresh what you publish. It doesn't create datasets on its own. The only reason you have to do it in this instance is you are likely using web.contents and they've mandated it with that connection likely due to security.