Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
SaharMa
Frequent Visitor

Sending a report's PDF to a specific distribution list

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.

1 ACCEPTED SOLUTION
collinq
Super User
Super User

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.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




View solution in original post

1 REPLY 1
collinq
Super User
Super User

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.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.