Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I hope everyone is doing well!
So I created a dashboard based on an original set of data.
In this post, I want to find out how to add to the original set of data and keep the visualisation the same?
I know I can add to the original excel dataset but there is a limit in terms of how much data I can add in there.
So I am thinking about adding the new data using a separate spreadsheet. This means each month/quarter, I will be able to update the dashboard with new data.
How do I go about doing that? Does this mean creating a relationship between exisiting data and the new data sets?
Thank you!
Solved! Go to Solution.
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.
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.
Hello,
I have a doubt like what if we want to delete the new dataset file since we appended it already to our old file, it is of taking some extra space in the model now. I came across similiar situation, but I am unable to delete the new dataset since I got a pop up saying you can't delete it because it is being referenced by another query.
Is there any other alternative to delete the newly imported file after we appending it to our old file.
Thanks for the help!
Hi @Anonymous ,
If the solution worked for you, can you please mark this as a solution for your question.
Thanks,
Pragati
Just use an Append Query or switch to using a Folder query.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |