topic Re: How to manage report subscriptions in Power BI cloud version using Power BI API? in Developer

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

felaray — Fri, 18 Oct 2024 09:34:45 GMT

Hi all,

I’m currently trying to manage report subscriptions in the cloud version of Power BI using the Power BI API. However, I haven't been able to find the correct API endpoint to achieve this. While searching through the documentation, I found that there are APIs available for managing subscriptions on Power BI Report Server (on-premises), but those are not applicable to the cloud service.

Has anyone successfully found the API endpoint for managing report subscriptions specifically on the Power BI cloud service (SaaS)? Any guidance or examples would be greatly appreciated!

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

Anonymous — Mon, 21 Oct 2024 06:30:10 GMT

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.

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

felaray — Mon, 21 Oct 2024 10:29:48 GMT

@Anonymous Thanks for getting back to me and for the detailed solution.

I've tried this approach before, but I noticed that the email formats from Power BI report subscriptions are different from those sent via Power Automate. With Power BI, you get a thumbnail image that you can click to see a larger version, while Power Automate just sends the PDF as an attachment.

Also, since the user has already set up a bunch of rules in the report, it would be way easier to enable or disable those through a RESTful API (if that’s available). Using Power Automate would mean rewriting all the logic for the report subscriptions.

The format issues might be solved with the Report Export File API, but the real headache is managing those subscription rules. So, having an API that can handle subscription management would be the best solution.

Anyway, thanks again for your detailed explanation and for confirming my tests! I spent a week looking for different ways to tackle this, and even tried the Fabric API. I really hope Microsoft will recognize this problem that so many users are facing and come up with a solution.

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

felaray — Mon, 21 Oct 2024 10:49:07 GMT

Vote this two idea for this topic.
Microsoft Idea
Microsoft Idea