callAsync PowerBI Refresh not working

[sebnickel]

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 says it should return a 202 (async) but it returns a 200 (sync). Why is it not working as it is documented?
The dataset I am refreshing is in a worksapce that is on a premium per-user license.

This is the part of the pipeline that does the call:

 {
                "name": "Call dataset refresh",
                "type": "WebActivity",
                "dependsOn": [
                    {
                        "activity": "Set Access token",
                        "dependencyConditions": [
                            "Succeeded"
                        ]
                    }
                ],
                "policy": {
                    "timeout": "0.00:05:00",
                    "retry": 0,
                    "retryIntervalInSeconds": 30,
                    "secureOutput": false,
                    "secureInput": true
                },
                "userProperties": [],
                "typeProperties": {
                    "method": "POST",
                    "headers": {
                        "Authorization": {
                            "value": "@variables('AccessToken')",
                            "type": "Expression"
                        },
                        "Prefer": "respond-async"
                    },
                    "url": {
                        "value": "@concat('https://api.powerbi.com/v1.0/myorg/groups/',pipeline().parameters.workspaceGuid,'/datasets/',pipeline().parameters.datasetGuid,'/refreshes')",
                        "type": "Expression"
                    },
                    "body": {
                        "value": "@pipeline().parameters.PowerBI_Refresh_API_Body",
                        "type": "Expression"
                    }
                }
            },

[v-kpoloju-msft]

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.