You can use the solution if you want to consume data in the report which consist of several data sources which have to be combined in one dataset you cannot use linked server for various mentioned reasons you cannot use other connection technologies like OPENROWSET/OPENDATASOURCE you do not have SQL Server at all as a data storage for your data source, e.g. source is a text file (???) use external