Sending a report's PDF to a specific distribution list

[SaharMa]

Hi all,

I have a PBI report that contains data from an API call and 4 different groups of users (Microsoft groups).
I'm trying to figure out how to create a trigger so that after the report is refreshed - the appropriate group will receive an email containing a PDF of the report and a link to it.

Something like:
Some action in my web app -> refreshing the report -> sending an email to the appropriate group with report's PDF.

I know that it is possible to refresh a report using rest API, but is it also possible to send an automatic email to a specific group that will be scheduled after the refresh is finished?

*Groups can be distinguished by a varible that is available in both PBI report and web app.

Thanks.

[collinq · Accepted solution]

Hey @SaharMa ,

If you are wanting to use API to send the file I believe that the Export to File will do the trick:  Reports - Export To File - REST API (Power BI Power BI REST APIs) | Microsoft Learn

If you are waiting until the Dataset is refreshed, then you can use this API call to determine if it is done or not:

Datasets - Get Refresh Execution Details - REST API (Power BI Power BI REST APIs) | Microsoft Learn

OR, you could use Power Automate to do all of this.