Consolidate Multiple Data Sources In. Multiple sources can be of three types. In the workbook into which you want to consolidate your data on the Data tab in the Data Tools group click Consolidate.
Click Add to Data Model in the Tables group. Your Excel data is safe--you cant edit the data in the Power Pivot view. To navigate to a specific data sources Data Source Pane The Data Source button in the lower left of Tableau Desktop frame Navigate first to a worksheet that is utilizing that data source.
There are different ways through which you can combine your data from multiple data sources in Google Data Studio.
Right-click the dashboard tab and then select Export. Connect to an Excel workbook. Select Data Get Data From File From Workbook. Open the workbook into which you want to consolidate your data and the workbooks supplying the data for the consolidated range.