Forum Discussion

BartVW's avatar
BartVW
Icon for Helper I rankHelper I
2 years ago
Solved

Enhanced refresh with the Power BI REST API - RequestId not valid

hi community   I'm creating a flow to perform a Power BI Enhanced dataset refresh.    According to the documentation, after doing the POST to refresh the dataset, the RequestId that is returned f...
Need Help
  • BartVW's avatar
    BartVW
    1 year ago

    In the meantime I found the reason for above behavior, thanks to Chris Webb's blog here.

     

    Turning off the Asynchronous Pattern option in the Settings dialog of the HTTP action did the trick for me.

     

     

  • BartVW's avatar
    BartVW
    Icon for Helper I rankHelper I
    2 years ago

    hi Anonymous 

     

    Your link describes the normal (non-enhanced) dataset refresh. The problem is that this only triggers the refresh, but doesn't provide any feedback on whether it was succesful or not. 

     

    The enhanced data set refresh allows to do this by doing the process in 2 steps: first call the dataset refresh api using POST and including a body to trigger it as an enhanced refresh operation, and then call the data set refresh api using GET to check the status of the refresh, using the requestId from the first step (as described in the documentation link I provided),  but for some reason it doesn't work as documented in Power Automate (and does work OK in Postman).

     

    So hope you or anyone else has an idea how to resolve this.

     

    Thanks

    Bart

    • BartVW's avatar
      BartVW
      Icon for Helper I rankHelper I
      1 year ago

      In the meantime I found the reason for above behavior, thanks to Chris Webb's blog here.

       

      Turning off the Asynchronous Pattern option in the Settings dialog of the HTTP action did the trick for me.