The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I'm calling the enhanced refresh API with this simple body
{
Does anyone have any idea what might be wrong?
Solved! Go to Solution.
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
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
}
]
}
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?
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".
User | Count |
---|---|
5 | |
2 | |
2 | |
2 | |
2 |
User | Count |
---|---|
11 | |
7 | |
5 | |
4 | |
4 |