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.
Thanks you for the quick response.
I am currently using Excel as my data source.
Can I set it up automatically?
Thanks!
Ashley
Community SupportHi Anonymous ,
To keep data up to date. We can set schedule refresh of the dataset. In your scernaio, Gateway is required. You can refer to the online document as below to know how to do that.
https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh