Report Subscription API

[srduval]

Is there any other subscription API besides the admin getsubscriptionsbyreport? It works all well and good except it leaves off a chunk of the data from the subscription tab in power bi I'm trying to extract the subject line used in the email that goes out, but that API doesn't return it the "email subject" in the screenshot below 

•  

[v-sshirivolu]

Hi @srduval ,

Since the API can’t pull that field directly, there are a few practical options you can try.

For quick checks or smaller needs, you can use the Power BI Service itself to view or export subscription details, including the subject line, from the Subscriptions tab on your reports. Admins who need a broader view can also use export options available in the Admin Portal, though those exports aren’t fully automated.

If you’re setting up new subscriptions, the Dynamic Subscriptions feature (available since 2024) lets you control the subject line from your data. When creating a subscription, choose Get from data for the recipients or subject field, and link it to a column in your dataset for example, Monthly Report – {Month}. Just note that this only works for new or updated subscriptions and can’t fetch subjects for existing ones.

Another approach is to use Power Automate or a custom script. You can combine API outputs with subject lines stored somewhere like SharePoint or a database to create a full subscription record. For more advanced automation, you can even use the Export to File API to generate reports and send them through Outlook or Gmail, giving you full control over the email subject and delivery.

Until Microsoft adds this capability to the API, these workarounds can help achieve a similar outcome. You might also want to post or upvote a feature request in the Fabric Ideas forum to help bring this functionality to future releases.

[srduval]

Thanks. I have only done 1 or 2 data driven subscriptions so I have to look more into that. Prior to power bi I used data driven subscritipions frequently in the way you mention or similar

[v-sshirivolu]

Hi @srduval ,
Regarding the Get from data option I mentioned earlier, that feature only applies to recipients (and titles in paginated reports), not to the subject line in standard subscriptions , just to clarify that point. For now, there are some of workarounds you can use. One is to export subscriptions directly from the report itself by going to Settings - Subscriptions and selecting Export to CSV, this export, introduced around March 2025, includes the exact subject line as it appears in the UI. The other option is through the Fabric Admin Portal, where you can navigate to Subscriptions and use the Export feature to retrieve a full tenant-level list that also includes subject lines.
In the longer term, the best way to get this capability added to the API is to vote for the related feature request in the Fabric Ideas forum. It’s already one of the most requested API enhancements, and additional votes help prioritize it for future updates.

[v-sshirivolu]

Hi @srduval ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you

[GilbertQ · Accepted solution]

Hi @srduval 

As far as I know that is all that it returns unfortunately. You can vote or create an idea here. https://community.fabric.microsoft.com/t5/Fabric-Ideas/idb-p/fbc_ideas 

[srduval]

Thanks @GilbertQ