Forum Discussion

MKN_PB's avatar
MKN_PB
Frequent Visitor
1 year ago
Solved

Automating Power BI Dashboard Refresh After Talend Job Execution

Hello everyone, My report refreshes automatically via the gateway every morning at 9 AM. However, there are times when the Talend job takes longer than expected and finishes after this time. In such...
Dataflow
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • Poojara_D12's avatar
    Poojara_D12
    1 year ago

    Hi MKN_PB 

    You can trigger a Power BI dataset refresh after the Talend job finishes using the Power BI REST API:

    1. Enable API Access in Power BI Admin settings.
    2. Register an Azure AD App to get an access token for Power BI.
    3. At the end of the Talend job, send an HTTP POST request to the API endpoint:
       

     

    https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/refreshes

     

    Replace {groupId} and {datasetId} with your workspace and dataset IDs.

     

    Alternatively, use Power Automate or Azure Automation to handle the refresh by triggering it through a webhook or script called by Talend.

    This ensures your refresh happens only after the Talend job completes.

     

    Did I answer your question? Mark my post as a solution, this will help others!
    If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

    Kind Regards,
    Poojara
    Data Analyst | MSBI Developer | Power BI Consultant
    Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS 

Poojara_D12's avatar
Poojara_D12
Super User
1 year ago

Hi MKN_PB 

You can trigger a Power BI dataset refresh after the Talend job finishes using the Power BI REST API:

  1. Enable API Access in Power BI Admin settings.
  2. Register an Azure AD App to get an access token for Power BI.
  3. At the end of the Talend job, send an HTTP POST request to the API endpoint:
     

 

https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/refreshes

 

Replace {groupId} and {datasetId} with your workspace and dataset IDs.

 

Alternatively, use Power Automate or Azure Automation to handle the refresh by triggering it through a webhook or script called by Talend.

This ensures your refresh happens only after the Talend job completes.

 

Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS