Forum Discussion

karthi_power_bi's avatar
karthi_power_bi
Frequent Visitor
2 years ago
Solved

Disable PowerBI Dataset Refresh - Using PowerBI REST API

All,

 

I have written a python script to disable a dataset's refresh schedule.

 

Reference Link : https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/update-refresh-schedule-in-group#disable-a-scheduled-refresh-example

 

Try 1: 

data = {"value": {'enabled': 'false'}}
datasets_request = json.loads(requests.patch(url=datasets_request_url, data=data, headers=header,verify=False).content)
print(datasets_request)
 
Output:

{'error': {'code': 'InvalidRequest', 'message': 'Refresh schedule refresh schedule request is empty'}}

 

Try2:  (Ran without 'Data')

 

datasets_request = json.loads(requests.patch(url=datasets_request_url, data=data, headers=header,verify=False).content)
print(datasets_request)
 
Output:
{'error': {'code': 'BadRequest', 'message': 'Bad Request', 'details': [{'message': "'datasetModelRefreshSchedule' is a required parameter", 'target': 'datasetModelRefreshSchedule'}]}}
 
Note: I have added a schedule for this dataset in the service.
 
What is missing here? why i'm not able to disable/Turn OFF the refresh schedule through REST API.
 
Need Help
  • karthi_power_bi's avatar
    karthi_power_bi
    2 years ago

    I changed from data = data  to json = data then it is working fine.

     

    data = {"value": {'enabled': 'false'}}
    datasets_request = json.loads(requests.patch(url=datasets_request_url, data=data, headers=header,verify=False).content)
    print(datasets_request)

1 Reply

  • karthi_power_bi's avatar
    karthi_power_bi
    Frequent Visitor
    2 years ago

    I changed from data = data  to json = data then it is working fine.

     

    data = {"value": {'enabled': 'false'}}
    datasets_request = json.loads(requests.patch(url=datasets_request_url, data=data, headers=header,verify=False).content)
    print(datasets_request)