Adding another set of data/ spreadsheet into existing visualisation

Hi Anonymous ,

I am assuming that your new excel spreadsheet with updates for every month/quarter will have similar structure to the data hat you have used for building your dashboard. If this is the case, you can append this new data to the existing data in Power BI Query Editor.

In Power BI, import this new excel file as a datasource. Go to Query Editor. Here you will see your old dataset and new dataset.

Click on your old dataset file in query editor and navigate to Append Queries option as shown below:

You can either append new data in existing datasource which is used for visualisations or append as a new.

I will suggest the "Append Queries" option in your case, which appends new rows to existing data.

Once you click on this, you get the following window as shown below:

Select your new dataset file here as indicated by arrow in the above picture. This will append the new data to old existing dataset.

This should work. Let me know how you get along with this.

Thanks.