Forum Discussion

jbranch's avatar
jbranch
Frequent Visitor
11 months ago
Solved

Run a Paginated Report for Yesterday

I have been asked to set up a daily report for a member of staff that lists the number of calls made using each of our external phone numbers. I have this data present in my semantic model that I use for a Power BI Dashboard, but would like to setup a paginated report that would send daily to the member of staff for yesterday. I have made the report and know how to set it up to send daily, but I am unable to figure out how to make the report to filter to just yesterday. I have tried to use a parameter for this but it just shows all of the individual values in a dropdown list instead of a relative date (as can be done in Power BI).

 

Is it possible to get a report to run daily for the previous day? Have I missed something?

Need Help
  • GilbertQ's avatar
    GilbertQ
    11 months ago

    Hi jbranch 

     

    Yes, this is possible and one of the easiest ways to do this is to create a date parameter for yesterday's date and then what you do is you create a filter where your parameter value is equal to the date value in your data. That should then filter out all the data to only show the rows for yesterday's date.

2 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    11 months ago

    Hi jbranch 

     

    Yes, this is possible and one of the easiest ways to do this is to create a date parameter for yesterday's date and then what you do is you create a filter where your parameter value is equal to the date value in your data. That should then filter out all the data to only show the rows for yesterday's date.

    • jbranch's avatar
      jbranch
      Frequent Visitor
      11 months ago

      Hi GilbertQ

       

      Thank you for your response. I assume this is something that must be done in the Report Builder, because there doesn't seem to be any functionality like this in the service (which seems bafflingly lacking, even for a preview). I tried to get it working in the way described but for some reason it wouldn't return any data for yesterday, but would for all previous days (not really sure why). In the end I ended up putting the data I needed into Power BI Desktop and used a slicer to filter it and copied the DAX from the query view into the Report Builder, which has worked.

       

      Thanks again for the pointers.