We need to export Power BI reports using the Power BI REST API and send them via email on a scheduled basis in a User Owns Data scenario. The challenge is that obtaining an access token requires user authentication, but we need a way to generate the token automatically without user interaction to support scheduled email delivery.
Requirement
We are looking for a solution to:
- Programmatically authenticate and retrieve an access token for Power BI APIs without manual login.
- Automate report exports and send them via email at scheduled intervals.
- Ensure compliance with User Owns Data authentication requirements while maintaining security best practices.
Has anyone successfully implemented this? What are the best practices to achieve this securely? Any guidance would be greatly appreciated!
