Currently, there is an Action to let us trigger the Power BI Semantic Model refresh through Logic App that uses the Power BI API connection (named "Refresh a dataset"); great! But there is no similar Power BI action to trigger the dataflow and we have to use HTTP action which has several disadvantages.
One important disadvantage is that once the HTTP request is submitted then the action is considered as completed and the logic app moves to the next step without waiting for the dataflow to be refreshed (successfully or not). With a Power BI action to refresh the Dataflow, the action would wait until the execution of the dataflow is a success or a failure and then return the output before to move to the next step/action. A workaround is to add a "Delay" step but with a fix value (example = 1mn) and there is no guarantee that the dataflow's refresh completes within that delay, as well as there is no control on the output of the refresh (whether the refresh fails or not, the logic app will continue to execute the next steps after that delay).
Another disadvantage by having to use HTTP request is that you cannot use the Power BI API connection through the HTTP request and you have to pass the access credentials information to the action to get the token prior to submit the request.
Also it would be very useful to add a Power BI action to let us refresh a Dataflow, thanks.
No CommentsBe the first to comment
