topic Re: Has anyone gotten this API to disable a Direct Query refresh that is enabled? in Developer

Has anyone gotten this API to disable a Direct Query refresh that is enabled?

mbutler71 — Wed, 29 May 2024 20:12:46 GMT

Datasets - Update Direct Query Refresh Schedule

datasets/$DatasetId/directQueryRefreshSchedule

Has anyone got this to work?

Trying to run this API and using the example on the Microsoft site:

https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/update-direct-query-refresh-schedule#code-try-0

With this JSON Body:
{ "value": { "enabled": false } }

This always brings back a 400 error:

{"error": {"code": "BadRequest","message": "Bad Request","details": [{"message": "Value cannot be null.\r\nParameter name: nullableType","target": "datasetDQRefreshSchedule"}]}}

Re: Has anyone gotten this API to disable a Direct Query refresh that is enabled?

Anonymous — Thu, 30 May 2024 02:16:23 GMT

Hi @mbutler71 ,

Make sure that your request contains all required parameters and that the access token used has the necessary permissions (The user must be the dataset owner).

There may be issues with the body of the request, be careful with how the attributes are set, make sure there are no trailing commas or syntax errors in the actual body of the request to be sent, and the JSON structure needs to conform to the API's expectations.

This is the related document, you can view this content:

Solved: Re: Power BI API doesn't disable Direct Query, but... - Microsoft Fabric Community

What is the correct JSON body to disable PowerBi Schedule Refresh via API - Stack Overflow

Solved: Keep getting a 400 Bad Request error when trying t... - Microsoft Fabric Community

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Has anyone gotten this API to disable a Direct Query refresh that is enabled?

mbutler71 — Thu, 30 May 2024 17:23:00 GMT

Thanks for replying.
I have reviewed all of the links you provided.
I tried the suggestions in all, with no success.

I am first trying to disable a scheduled Direct Query Refresh in the Leaning Microsoft test page.

And this is also not working here either.
I am using the exact JSON body in the example: