topic Power BI API Dataflow Refresh Operation in Developer

Power BI API Dataflow Refresh Operation

Anonymous — Wed, 19 Dec 2018 13:50:05 GMT

Hi all, I am testing Dataflow API Refresh dataflow function. I send this POST request with Postman:

POST https://api.powerbi.com/v1.0/myorg/groups/<MYGROUPID>/dataflows/<MYDATAFLOWID>/refreshes HTTP/1.1
Authorization: Bearer <MYTOKEN>
cache-control: no-cache
Postman-Token: c1c8e0e7-3bc0-47df-8071-5919cf7f199a
User-Agent: PostmanRuntime/7.4.0
Accept: */*
Host: api.powerbi.com
accept-encoding: gzip, deflate
content-length: 0
Connection: close

The response is this error:

{
    "error": {
        "code": "BadRequest",
        "message": "Bad Request",
        "details": [
            {
                "message": "'refreshRequest' is a required parameter",
                "target": "refreshRequest"
            }
        ]
    }
}

There is no info in the oficial doc about parameter refreshRequest. Any info about this parameter?

Thanks.

Regards

Re: Power BI API Dataflow Refresh Operation

v-jiascu-msft — Mon, 24 Dec 2018 09:44:52 GMT

Hi @Anonymous,

Please add a request body like below. Please refer to the snapshot below.

{
	"refreshRequest": "y"	
}

Best Regards,
Dale

Re: Power BI API Dataflow Refresh Operation

Anonymous — Mon, 24 Dec 2018 10:09:41 GMT

Hi @v-jiascu-msft, solution checked. Refresh request is working.

Thanks!!

Kind regards,

Joseba

Re: Power BI API Dataflow Refresh Operation

Anonymous — Tue, 15 Jan 2019 11:00:47 GMT

Hi @v-jiascu-msft,

I'm having the same issue in Microsoft Flow. I created a custom connector refreshing a dataset in Power BI, and it works well when I test it, but when I put it in a flow I get the same "refreshRequest required" error @Anonymous found above.

I tried to put your code snippet in the POST function of the custom connector but the issue hasn't been resolved.

Any idea on how I could fix it?

Thank you very much,

Re: Power BI API Dataflow Refresh Operation

v-jiascu-msft — Wed, 16 Jan 2019 02:19:03 GMT

Hi @Anonymous,

Since you added a request body, did you also add the header "Content-Type: application/json"? I would suggest you go to Microsoft-Flow-Community for more precise support.

Best Regards,

Re: Power BI API Dataflow Refresh Operation

Anonymous — Wed, 16 Jan 2019 08:32:11 GMT

Hi @v-jiascu-msft,

seems like I just had to add a default value for refreshRequest in the body settings, and force a cache refresh via CTRL+f5.

Thank you very much for your help anyway!