Forum Discussion
report output as attachment
I think I know the answer to this one, my users are used to getting report outputs as excel attached in their emails?
Is there a way in power bi where report output can be attached in emails as excel or pdf ? If not, can I contact the product team to have this feature added pleaese ?
9 Replies
- GilbertQ
Super User
Hi there
This can be done using the Power BI REST API
Here are more details: https://powerbi.microsoft.com/en-us/blog/export-report-to-pdf-pptx-and-png-files-using-power-bi-rest-api/- AnonymousNot applicable
1. I have never used an API in power bi, does it require c# knowldege, can anyone please share with me an example of export to file api and how to use it ?
2. Is it true my workspace has to be premium to be able to use export to File api ?
- GilbertQ
Super User
Hi there
Chris Webb actually just created an awesome blog post on how to do this
https://blog.crossjoin.co.uk/2020/04/25/calling-the-power-bi-export-api-from-power-automate-part-1-creating-a-custom-connector/
- Ludia
Helper I
If you don't want to add any code, you can send the report as a pdf with a link to your user by "Subscribe to emails" in power bi service, but unfortunately, there is no excel version supperted there
- AnonymousNot applicable
they want excel as an output, so i guess its visual studio ssdt 2017 or power bi report server ? and then export to file api ?