Forum Discussion
How to update existing dashboard with new data?
Exactly correct. As long as the form of the data is the same (same columns, same tables, etc) and it's just the actual values that change, any measures, calculated columns, or data transformations apply the same way.
It's like if you went to your original data and changed a 10 to an 11, or deleted a random entry. You'd still expect PowerBI to work on that updated file. This is the same idea, but you're changing a lot more values at once.
Resident RockstarThe easiest way would be to simply replace the file contents with the new data. This can be done either by copy/pasting the data into the master file, or just renaming the file to whatever filename PowerBI is expecting each week.
There are ways to automate this, but they get much more complicated, and depend on how you get your excel file in the first place. You can start reading here on how to do that, and find a solution that works for you.
Hi Cmcmahan,
If I created new measures/columns with my previous data set, will the same measaures apply to my new data if I use any of the following methods that you suggested? Assuming that the datasets have the same table names.
Thanks!
Ashley
- Cmcmahan
Exactly correct. As long as the form of the data is the same (same columns, same tables, etc) and it's just the actual values that change, any measures, calculated columns, or data transformations apply the same way.
It's like if you went to your original data and changed a 10 to an 11, or deleted a random entry. You'd still expect PowerBI to work on that updated file. This is the same idea, but you're changing a lot more values at once.