How to manage report subscriptions in Power BI cloud version using Power BI API?

Hi, felaray 

I think your idea is great! However, currently, there is no direct API to automate Power BI service subscriptions. But you can try using Power Automate to automatically create and send emails. This method still has some limitations, so you can choose based on your needs:

1.First, log in to Power Automate and create a new flow. Choose an appropriate trigger, such as "When a new item is created" in a SharePoint list or "When an email arrives" in Outlook.

2.Next, add the necessary actions to your flow. For example, you can use the "Send an email" action to automate the email sending process. You can also include conditions to check specific criteria before sending the email.

3.Finally, test your flow to ensure it works as expected, then save and activate it.

4.For more details, you can refer to the following link:

Export and email a report with Power Automate - Power BI | Microsoft Learn

Create flows for popular email scenarios in Power Automate - Power Automate | Microsoft Learn

5.I also found the API for exporting files, which I hope will be helpful to you:

First, you can use the following API to generate the export ID:

POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/reports/{reportId}/ExportTo

Reports - Export To File In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Next, use the following API to retrieve the exported file:

GET https://api.powerbi.com/v1.0/myorg/groups/{groupId}/reports/{reportId}/exports/{exportId}/file

For more details, please refer to:

Reports - Get Export To File Status In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

If you feel that performance needs to be improved, you can also submit an idea on

https://ideas.fabric.microsoft.com/ and wait for users with the same needs as you to vote for you and help you realize the idea as soon as possible. Many features of our current products are designed and upgraded bed on customers’ feedback.  With requirements like this increase, the problem may well be released in the future.

Thanks for your understanding.

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.