Forum Discussion

EstherBR's avatar
EstherBR
Helper III
1 year ago
Solved

Control M & Power BI

Hi,

 

We would like to orchestrate the dataflows in Power BI Service with Control M. The goal is to launch the dataflows, check that they are executing correctly and, if not, relauch it again. Do you know how we achieve that?

Is there any training or documentation in this regards?

Thank you so much!

Need Help
  • Shahid12523's avatar
    Shahid12523
    1 year ago

    You can orchestrate Power BI dataflows with Control-M like this:

     

    Install Control-M Power BI plugin → supports cloud dataflows via Service Principal.

    Create jobs in Control-M to trigger dataflow refreshes.

    Monitor execution and outputs directly in Control-M.

    Handle failures with retries, dependencies, and SLAs.

4 Replies

  • rohit1991's avatar
    rohit1991
    Super User
    1 year ago

    Hi EstherBR 

    You can do this by using the Power BI REST API and letting Control-M call it. The setup is:

    1. Create an Azure AD app (service principal) and give it access to your Power BI workspace.

    2. In API permissions, grant Dataflow.ReadWrite.All and enable “Allow service principals to use Power BI APIs.”

    3. From Control-M, first request an OAuth token from Azure AD.

    4. Use that token to trigger the dataflow refresh (POST …/dataflows/{id}/refreshes).

    5. Then check the refresh status (GET …/dataflows/{id}/refreshes). If it failed, Control-M can simply call the refresh again.

    That’s the supported way to launch, monitor, and retry dataflows from an external scheduler. If you prefer a Microsoft-native option, Fabric Pipelines or Power Automate can also handle orchestration and retries.

  • Shahid12523's avatar
    Shahid12523
    Community Champion
    1 year ago

    You can orchestrate Power BI dataflows with Control-M like this:

     

    Install Control-M Power BI plugin → supports cloud dataflows via Service Principal.

    Create jobs in Control-M to trigger dataflow refreshes.

    Monitor execution and outputs directly in Control-M.

    Handle failures with retries, dependencies, and SLAs.

  • v-menakakota's avatar
    v-menakakota
    Community Support
    1 year ago

    Hi  EstherBR 

    Thanks for reaching out to the Microsoft fabric community forum. 

     

    I would also take a moment to thank Shahid12523  and rohit1991 , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

    As mentioned above there are two main supported approaches, Using the Power BI REST APIs and Using the Control-M Power BI Plugin. If I misunderstand your needs or you still have problems on it, please feel free to let us know.   

     

    Best Regards, 
    Community Support Team