Forum Discussion

mollycat's avatar
mollycat
Icon for Helper II rankHelper II
4 years ago

Help using parameter to load data on demand after scheduled refresh

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 appl...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
    mollycat
    Icon for Helper II rankHelper II
    4 years ago

    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! 🙂