Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello,
How do you schedule report subscription to email you on the last day of every month? I see the box "Every month on day(s)" but not sure how to enter the value(s) since not all months have 31 days. Do you enter 29, 30, 31???
Solved! Go to Solution.
I'm afraid currently power bi doesn't have such option like "last day in a month".
Actually it's not very user friendly, you can submit your idea here to help power bi improve.
Regards,
Jimmy Tao
Thanks Jimmy. I can't believe Microsoft hasn't implemented this simple feature already! Just voted and keep my fingers crossed it will be available soon.
I'm afraid currently power bi doesn't have such option like "last day in a month".
Actually it's not very user friendly, you can submit your idea here to help power bi improve.
Regards,
Jimmy Tao
Thanks Jimmy. I can't believe Microsoft hasn't implemented this simple feature already! Just voted and keep my fingers crossed it will be available soon.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!