Forum Discussion
Enhanced refresh api status 202 OK but dataset is not refreshing
- 1 year ago
Yes, "automatic" will check if there is anything to refresh. If the service decides that nothing has changed it will not refresh the partition. You can override that with "full".
It's just a request, not a refresh. Your request may be accepted but still not be implemented. You can use the requestid to inquire the status.
Enhanced refresh with the Power BI REST API - Power BI | Microsoft Learn
- BartVW1 year ago
Helper I
Thanks @lbendlin
This is the request status I get. I don't really see anything that tells me why it is not working. Would you have any idea?{ "startTime": "2024-11-26T09:34:21.513", "endTime": "2024-11-26T09:34:30.433", "type": "Automatic", "commitMode": "Transactional", "status": "Completed", "extendedStatus": "Completed", "currentRefreshType": "Automatic", "numberOfAttempts": 0, "objects": [ { "table": "DateTableTemplate_4db2717a-c750-4e65-aa7e-944ab850ff2f", "partition": "DateTableTemplate_4db2717a-c750-4e65-aa7e-944ab850ff2f", "status": "Completed" }, { "table": "Source data", "partition": "Source data", "status": "Completed" } ], "refreshAttempts": [ { "attemptId": 1, "startTime": "2024-11-26T09:34:22.5574511Z", "endTime": "2024-11-26T09:34:30.4328433Z", "type": 0 } ] }- BartVW1 year ago
Helper I
Having said the above, I played around a bit more with the POST request body. I found that if I include
"type": "Full"in the body, it works OK. So it seems the default type "Automatic" is not doing anything.
Not sure if this makes sense though, as the documentation says "Automatic" is the default?- lbendlin1 year ago
Super User
Yes, "automatic" will check if there is anything to refresh. If the service decides that nothing has changed it will not refresh the partition. You can override that with "full".