Hi
Please suggest on the use case scenario:
I've live office connections getting data in excel Sheet1. Sheet2 has forumales (serving what-if analysis) referenching Sheet1.
Dashboard shows sheet2 data.
Use Case: User Opens dashboard > Clicks on Connection Refresh Button to get latest data > Does What-if analysis using Slideres > Use Reset function that will reset the what-if and show the data that was brought back after connection was refreshed
I used Reset component but this resets the model to the stale excel data that resided in the underlying excel at the time the dashboard was developed and published
I also tried Push component, by mapping its source and destination, both, to sheet1 data but it does nothing (which I presume is because it only supports single-cell value insert?)
Please suggest on how this functionality can be achieved?
Thanks
Deep