Forum Discussion

Himanshu_G's avatar
Himanshu_G
Helper I
1 year ago
Solved

Generate Power BI API Token Without User Interaction for Scheduled Report Exports

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...
Power BI Service
REST API
  • v-prasare's avatar
    v-prasare
    1 year ago

    Hi Himanshu_G,

    Can try using a Service Principal (App Owns Data) is a secure, scalable, and reliable way to automate Power BI report exports. It lets your system access Power BI without needing a user to log in, making it perfect for scheduled tasks. This approach ensures that reports are delivered consistently and securely, while also reducing manual work—providing a better experience for your team and your customers.

     

    Please refer to below documentation for same and let me know if this helps.
    https://learn.microsoft.com/en-us/power-bi/developer/embedded/embed-service-principal?tabs=azure-portal

     

     

     

    Thanks,

    Prashanth Are

    MS Fabric community support

v-sathmakuri's avatar
v-sathmakuri
Community Support
1 year ago

Hi Himanshu_G ,

 

Thank you for reaching out to Microsoft Fabric Community.

 

using service account or service principal are the possible solutions.

 

Could you share a bit more about the constraints or requirements you're working with? For example:

  • Are service principals or app registrations not allowed in your environment?

  • Is the report being exported tied to per-user row-level security (RLS)?

Once I have a better idea of the exact boundaries, we can provide you the best solution possible. 

 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

 

Thank you!!

v-sathmakuri's avatar
v-sathmakuri
Community Support
1 year ago

Hi Himanshu_G ,

 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

 

Thank you!!