Forum Discussion

sebnickel's avatar
sebnickel
New Member
7 months ago
Solved

callAsync PowerBI Refresh not working

Hi, I am refreshing PowerBI through an ADF pipeline and I am calling the endpoint specified in this [documentation](https://learn.microsoft.com/en-us/power-bi/connect-data/asynchronous-refresh) It ...
Need Help
  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    7 months ago

    Hi sebnickel,

    Thank you for reaching out to the Microsoft Fabric Community Forum. 

    The behaviour you are seeing is expected based on your workspace setup. Even though the Prefer: respond-async header is included, asynchronous dataset refresh is only supported when the workspace is hosted on Premium capacity (P/EM/A SKU). Since your dataset is currently in a Premium Per User (PPU) workspace, Power BI automatically switches to a synchronous refresh, which returns 200 OK, rather than the expected 202 Accepted. So, your call is correct, but async mode isn’t enabled on PPU.

    If you want asynchronous behaviour (202 + refresh operation ID), the workspace will need to be moved to Premium capacity. If you continue using PPU, refreshes will still run successfully just synchronously so a 200 response is expected.

    More details are available here in Microsoft’s documentation: Enhanced refresh with the Power BI REST API - Power BI | Microsoft Learn

    Hope that clarifies. Let us know if you have any doubts regarding this. We will be happy to help.

    Thank you for using the Microsoft Fabric Community Forum.

v-kpoloju-msft's avatar
v-kpoloju-msft
Community Support
7 months ago

Hi sebnickel,

Thank you for reaching out to the Microsoft Fabric Community Forum. 

The behaviour you are seeing is expected based on your workspace setup. Even though the Prefer: respond-async header is included, asynchronous dataset refresh is only supported when the workspace is hosted on Premium capacity (P/EM/A SKU). Since your dataset is currently in a Premium Per User (PPU) workspace, Power BI automatically switches to a synchronous refresh, which returns 200 OK, rather than the expected 202 Accepted. So, your call is correct, but async mode isn’t enabled on PPU.

If you want asynchronous behaviour (202 + refresh operation ID), the workspace will need to be moved to Premium capacity. If you continue using PPU, refreshes will still run successfully just synchronously so a 200 response is expected.

More details are available here in Microsoft’s documentation: Enhanced refresh with the Power BI REST API - Power BI | Microsoft Learn

Hope that clarifies. Let us know if you have any doubts regarding this. We will be happy to help.

Thank you for using the Microsoft Fabric Community Forum.

  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    Community Support
    7 months ago

    Hi sebnickel,

    Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.

    Thank you.

    • v-kpoloju-msft's avatar
      v-kpoloju-msft
      Community Support
      6 months ago

      Hi sebnickel,

      Just wanted to follow up. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.

      Thank you.