Help using parameter to load data on demand after scheduled refresh

[mollycat]

Hello! I have a report that sources data from a table with 1 million+ rows over the last 6 years. By default, I have a scheduled refresh running daily to load data within the last 1 year (filter applied in the source query). However, I also need the ability to load additional historical data as-needed.

What I've done so far:

• Created a parameter
• Updated the source M query to reference the parameter (rather than hard-coding to calculate today's date minus 1 year)

Now I'm stuck - I'm not sure how to:

1) implement a user interface within the report where a user can select a date (from a list of distinct dates within a table?), link/assign that value to the parameter, and then kick off a data refresh to then re-load the data using the new parameter value in the query.

2) make it so that, if possible, the parameter value resets each day so that the scheduled refresh runs as expected with just the 1-year's worth of data.

Any help on this is appreciated 🙂

[v-eqin-msft]

Hi @mollycat ,

1. I have a scheduled refresh running daily to load data within the last 1 year (filter applied in the source query).

You may mean intremental refresh

2.For question1) ,you may create paginated report visual:

This visual brings the power of paginated reports to your Power BI reports. You can map fields from your Power BI dataset to be used as parameter values for your paginated report visual. The ability to map fields provides a fully interactive experience like any other visual.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mollycat]

Hi Eyelyn, thank you for the response!

I actually am not using incremental refresh, just a scheduled refresh running once daily.

I have not heard of paginated reports, but will look into this!

I appreciate your time, thank you! 🙂

[mollycat]

I will add that I tried to bind the parameter to a table column I created with a list of dates (starting 1/1/2016 through today), but am not seeing the option visible to bind the column to the paramenter. From what I can tell, this is because I am using data import rather than data direct?