Please provide functionality so that when datasets are being created, we can use data from multiple data sources.
Shared datasets can be created and shown to the user for reporting building. User can also upload their own "datasources" to create their own datasets; such as uploading an Excel file. However it is difficult to use uploaded data sources (such as Excel) with other embedded shared datasources.
For example. An embedded data source contains tables such as customer information and daily sales data. A user then uploads an Excel file with monthly sales target measures. Rather than attempt to use complicated expressions to bring the data together, create functionality in the dataset designer to use data from both the shared datasource data, and the uploaded Excel file datasource data. The designer then uses the "join" feature to create the relationships with each - just as it currently does but with current datasource entities.