Forum Discussion
Helper VEdit parameter functionality options
Absolutely would take longer but generally you automate the refresh of the data in the Service. Also, Power BI recently released Incremental Refresh so after the initial data load, you could potentially configure incremental refresh to only grab the new data when refreshing the data.
Or, it might make sense in your case to use a Direct Query (live) connection to the database. In that case, you aren't loading any data at all but rather as the user selects dates in the slicer, Power BI is live querying the database to bring back the information. I've seen this scale to millions or even billions of rows of data and it is amazingly fast.
Bottom line, there is no better way to improve the user interface/experience if you are going to do this via query parameters. What you are doing is the best you are going to get right now. It's just how query parameters work. If you want a better user experience, you are going to need to go another route.
Have you considered passing parameters to a stored procedure? I found this link, not sure if it helps or not
Helper VI reviewed the link. Thats exactly the process I am following (multi step). So basically query having a parameter like '"&StartDate&"' or stored proc having a parameter '"&StartDate&"' will have same steps when you need to change the parameters and refresh the universe. Thanks!