Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
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.
There are other ways like Power Automate, data driven
https://debajmecrm.com/how-to-get-last-day-of-current-month-in-power-automate/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
6 | |
4 | |
3 | |
3 |
User | Count |
---|---|
15 | |
9 | |
5 | |
3 | |
3 |