Enhanced refresh with the Power BI REST API using Python - need help

[satishorre20]

Hello,

I hope you're all doing well. I wanted to reach out to see if anyone has had success using the enhanced refresh with the Power BI REST API to refresh datasets with specific tables in the request body. Despite following the documentation closely, I'm still encountering an issue where the request is being submitted as "via API" rather than "via enhanced API."

Has anyone attempted to use the enhanced API call with Python for refreshing the dataset? Any insights or guidance on this would be greatly appreciated.

Documentaiton Link : Enhanced refresh with the Power BI REST API - Power BI | Microsoft Learn

API :  Post  https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/refreshes

Python POST API Sample code 

url_rfsh_data = f'https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/refreshes'

headers = {

    'Authorization' : 'Bearer ' + result['access_token']

   , "Content-Type"  :"application/json"

}

payload = {  "type": "Full"

          ,  'commitMode' : 'transactional'

          ,  "maxParallelism"  : 2

          , 'retryCount' : 2

          , 'objects' : [ { "table" : " DateDim"}

                        ]

          }

response = requests.post(url_rfsh_data,headers=headers, params=payload)

[tayloramy · Accepted solution]

Hi @satishorre20,

in my experienve, if the refresh shows “via API” it usually means the request didn’t include the enhanced options in the JSON body, or the dataset isn’t on Premium/PPU/Fabric. In your sample you used params=payload (query string) instead of json=payload (request body), so the service probably treated it like a standard refresh.

 

1. Make sure the workspace is on Premium/PPU or Fabric. Shared/Pro won’t run enhanced refresh. Datasets - Refresh Dataset
2. Send your POST with a JSON body that includes at least one enhanced property like objects, commitMode, maxParallelism, or retryCount. Enhanced refresh with the Power BI REST API
3. Try this minimal Python example (note the json=):

import requests

url = f"https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/refreshes"
headers = {
  "Authorization": f"Bearer {result['access_token']}",
  "Content-Type": "application/json"
}
payload = {
  "type": "Full",
  "commitMode": "transactional",
  "maxParallelism": 2,
  "retryCount": 2,
  "objects": [ { "table": "DateDim" } ]
}
r = requests.post(url, headers=headers, json=payload) # <-- use json, not params
print(r.status_code, r.text)​

Reference examples and parameters here: Enhanced refresh

• Confirm it shows “Via enhanced API” in the refresh history (or pull it programmatically). Get Refresh History In Group

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
Taylor Amy.

[satishorre20]

Thank you @tayloramy it worked