Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
mbutler71
Advocate I
Advocate I

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

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:

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"}]}}
2 REPLIES 2
mbutler71
Advocate I
Advocate I

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:

mbutler71_0-1717089677458.png

 

mbutler71_1-1717089773988.png

 

 

v-yangliu-msft
Community Support
Community Support

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.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.