Forum Discussion
Helper IIIEnhanced REST API table partition stopped working
Thank you for the answer. THe refresh policy otion is not working, when added.
The body part should be correct, i make a copy from SSMS (from the XMLA script).Most interesting is, that the commands worked, and after weekend, it stoped. There is no error returned (have modified the body so that i get error and then corrected).
WS is premium.
Hi tomas12344 ,
You can refer the following links to refresh partition by REST API:
Datasets - Refresh Dataset - REST API (Power BI Power BI REST APIs) | Microsoft Learn
{
"type": "full",
"commitMode": "transactional",
"objects": [
{
"table": "Customer",
"partition": "Robert"
}
],
"applyRefreshPolicy": "false"
}Using the Power BI Async REST API to refresh a partition with Power Automate (Using an HTTPS URL)
There could be a few reasons why the Power BI REST API is not refreshing a specific partition of a table. One possibility is that the table does not have an incremental refresh policy. For tables with no incremental refresh policy, that one partition contains all rows of data for that table, unless filters have been applied.
Another possibility is that the request payload for the POST /refreshes method is not set correctly. An enhanced refresh is triggered only if a request payload other than notifyOption is set. For enhanced refresh, notifyOption is not required and must be excluded from the request body. However, one or more parameters other than notifyOption are required.
Datasets - Refresh Dataset - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Best Regards
Helper IIIThank you for the answer. THe refresh policy otion is not working, when added.
The body part should be correct, i make a copy from SSMS (from the XMLA script).
Most interesting is, that the commands worked, and after weekend, it stoped. There is no error returned (have modified the body so that i get error and then corrected).
WS is premium.