Forum Discussion
Subscription in Power BI Service
Hello,
I am setting up subscription for Power BI Reports but I dont see the following custom options like in report server
1. Bi Weekly option -Monday's
2. Last Friday of the Month
3. Bi-Weekly -(Last Friday and 15th of the Monday)
Any Idea on this
Thanks
Hi mjsystemss
In the Power BI Service, the subscription scheduling options are currently limited compared to those available in Power BI Report Server (PBIRS). While PBIRS allows for highly customizable schedules—such as bi-weekly deliveries, the last Friday of the month, or specific day combinations like the 15th and last Friday—Power BI Service only supports basic frequencies such as daily, weekly, and monthly. There’s no built-in way to define complex recurrence patterns or conditional scheduling (e.g., “every other Monday” or “last Friday of each month”) directly in the Service interface. To achieve similar functionality, you can either (1) create multiple subscriptions with different dates that together approximate your desired schedule, (2) use Power Automate to trigger report exports and email deliveries on specific days or recurrence rules, or (3) use dynamic per-recipient subscriptions (if your environment supports it) in combination with external scheduling logic. Unfortunately, unless Microsoft expands the subscription options in Power BI Service to match the flexibility of PBIRS, complex schedules must be handled through automation or creative workarounds outside the standard subscription interface.
Hello,
Yes I have resolved it. I used Power automate work flow to work around it.
Thanks
6 Replies
Hi. I'm sorry but that's not possible, you can only pick a period like daily, weekly, monthly and then configure days like it's explained here: https://learn.microsoft.com/en-us/power-bi/collaborate-share/end-user-subscribe?tabs=creator#subscribe-to-a-report-or-dashboard
As an alternative, you could create a Power Automate flow with a message or link to the report. It won't have a preview of the report but could help.
I hope that helps,
Hi mjsystemss,
If you get a little crafty, you can do this with your own Notebook in Fabric by hitting the export to file API: Reports - Export To File - REST API (Power BI Power BI REST APIs) | Microsoft Learn to generate the preview, and then sending your own email with an outlook activity.
Make the notebook export the report to a PDF and save it in a lakehouse, then have a pipeline that does the following:
1: checks the day to see if it is the correct day for the schedule you want2: run the notebook to download the PDF file
3: send an email with the outlook activity
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
Hi mjsystemss ,
Thank you for reaching out to Microsoft Fabric Community.
Thank you tayloramy ibarrau for the prompt response.
I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.
Thank you.
Hi mjsystemss ,
May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.
Thank you.
Hello,
Yes I have resolved it. I used Power automate work flow to work around it.
Thanks
Hi mjsystemss
In the Power BI Service, the subscription scheduling options are currently limited compared to those available in Power BI Report Server (PBIRS). While PBIRS allows for highly customizable schedules—such as bi-weekly deliveries, the last Friday of the month, or specific day combinations like the 15th and last Friday—Power BI Service only supports basic frequencies such as daily, weekly, and monthly. There’s no built-in way to define complex recurrence patterns or conditional scheduling (e.g., “every other Monday” or “last Friday of each month”) directly in the Service interface. To achieve similar functionality, you can either (1) create multiple subscriptions with different dates that together approximate your desired schedule, (2) use Power Automate to trigger report exports and email deliveries on specific days or recurrence rules, or (3) use dynamic per-recipient subscriptions (if your environment supports it) in combination with external scheduling logic. Unfortunately, unless Microsoft expands the subscription options in Power BI Service to match the flexibility of PBIRS, complex schedules must be handled through automation or creative workarounds outside the standard subscription interface.
