Forum Discussion
Refreshed Data Sets not staying Refreshed Query
Hi,
I have built a Power BI app that looks at a single weeks performance and have created @StartDate parameter for the first day of the week. The SQL query is fairly complex with several temp tables. I then used the query to build the dataset which runs the app. It automatically runs the current week without the users having to do anything. They like it but now want to select previous weeks. I can build a slicer filter with the StartDate weeks but what I need to do is to find a way to pass the StartDate to the underlying query and have it rerun the data. The query is too complex to simply run multiple weeks and then filter on one week of results. Is there a way to create a parameter that when clicked on will rerun the underlyingquery with a previous weeks results?
Thanks
No, but they can edit the parameter and refresh the query.
Generally though, you just import everything and filter from there.
1 Reply
- Greg_DecklerCommunity Champion
No, but they can edit the parameter and refresh the query.
Generally though, you just import everything and filter from there.