Using Report filter and subscribed to emails

[Louis_Sands]

I have several pages setup in a report and they work as intended. A page level filter is setup on each page as "Relative Date is in this week" so I can schedule a nightly report run and send it to the leadership team. The subscription is setup to run at 11pm each night, after the data is imported. The problem: when the report runs on Saturday, the scheduler uses UTC and the filter thinks the report is being run on Sunday, so the daily report for the last day of the week has no data. I can't run the report earlier.

Any suggestions on how to get the report to run on Saturday with the current week's data? Is there a way to pass the page filter parameters? Do I have to duplicate the report and change the filter for just that one run? Any help is much appreciated.

[v-henryk-mstf]

Hi @Louis_Sands ,

Do you know anything about converting UTC to local date and time?

Converting UTC to local datetime in Power BI – Cloud BI

Also see if a similar solution helps you.

Solved: How can I change the UTC time in Power BI Service? - Microsoft Power BI Community

Set local time zone Power BI Service - Microsoft Power BI Community

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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

[Louis_Sands]

Thank you for your reply Henry.

I don't believe the issue is with my data or the calendar. The PBI server uses UTC for everything. When the page filter is set to "Relative date this week" it uses the UTC and drops the data for my current week because it thinks in terms of a UTC week. If I use a date range then the data pulls correctly. It's the internal translation of what a week means. If I run all of my reports before 8PM EST I will get the correct data (until DST is over then I'm forced to 7pm). If the business doesn't close until 6:30pm, and the data extract takes 1 hour, I'm out of time.