- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Subscribe a report on last day of the month
Hello,
i am currently working on paginated reports, one the reports need to be shared with users on the last day of the month
as some months have 31 days some have 30 days,
can it done by creating a single subscribtion or should i create two seperate subscribtions one for months with 30 days and other for months with 31days.
Thanks and Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I found a workaround that is applicable for most of the world:
- schedule the report to run on the first of every month at 12:45 am in timezone UTC+12
That way it will actually run in the last day of the previous month as long as your timezone is less that UTC+11.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This worked out great for us! We are in CST so for us 9:30AM UTC+12 on the 1st converted to the last day of the month at 4:30PM. 😀
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @SSWADOOD ,
It seems that for now, Power Bi does not have the option of "last day of the month".
But there is an alternative that is a workaround: an option to run the subscription on the first day of the month that defaults the report to the previous month. To make this an option, you need: 1. the data parameters in the report and 2a. the report already defaults to last month or 2b. a SQL Server version that supports data-driven subscriptions to override the default parameters to last month.
For more details, you can read this blog:
Report Manager Subscription Last Day of Month – The Data Queen (unlimitedviz.com)
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi Henry thanks for the message, i will test this on the report.....
for now i had created 3 subscriptions
first one for 28 days of Feb
second one for months with 30 days
third one for months with 31 days
i will probably shift to single subscription option via SSMS.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- on the 30th day of April, June, September & November
- on the 31st day of January, March, May, July, August, October & December
- on the 28th day of February
Not sure you want to create one more for leap year 😉
There are other ways like Power Automate, data driven
https://debajmecrm.com/how-to-get-last-day-of-current-month-in-power-automate/
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
Subject | Author | Posted | |
---|---|---|---|
06-27-2024 12:52 PM | |||
06-25-2024 12:42 PM | |||
02-15-2024 02:08 PM | |||
Anonymous
| 07-05-2024 07:22 AM | ||
05-12-2024 05:57 PM |
User | Count |
---|---|
3 | |
1 | |
1 | |
1 | |
1 |