Forum Discussion
Dataflow Gen2
- 9 months ago
Power Automate is failing due to response format, not due to refresh failure.
=======================
The refresh is actually succeeding. The failure is coming from power automate because dataflow gen2 does not return a clean 200 success response to the pre-authorized HTTP call. Instead, it returns an intermediate or empty response that Power Automate interprets as an error, even though Fabric completes the refresh in the background.
Reason why this happens?
• Gen2 refresh is asynchronous. The API triggers the job and exits without a proper success payload.
• Power Automate expects a standard 2xx response with a body, so it marks the action as failed.How can you fix it?
• Wrap the HTTP action with “Configure run after” and treat failure as success if the Fabric refresh actually triggers.
• Or use the Fabric REST API for item refresh (preview) that returns proper status codes.
• Or add a follow-up GET call to poll the refresh history and decide success based on that instead of the initial trigger call.
Hi PBI_Admin12,
We are following up to see if what we shared solved your issue. If you need more support, please reach out to the Microsoft Fabric community.
Thank you.