Enhanced Refresh API Incremental Refresh - Cannot specify partition

[naelske_cronos]

Hello,

I'm creating a python script that refreshes my partitions via the enhanced refresh API, like in this example from Rui Romano: https://www.linkedin.com/pulse/approach-custom-partition-your-power-bi-dataset-refresh-rui-romano/?t...

Regarding the refresh of my dimensions without partitions it works perfectly.

{
     "type": "full",
     "commitMode": "transactional",
     "maxParallelism": 10,
     "retryCount": 1,
     "objects": [
         {
          "table": "DIM_PHASE"
        }
    ]
}

As soon as I want to refresh a partition like this, it fails:

{
     "type": "full",
     "commitMode": "transactional",
     "maxParallelism": 10,
     "retryCount": 1,
     "objects": [
         {
          "table": "FACT_BENCHMARKING",
          "partition": "2023Q101"
        }
    ]
}

I'm getting an error that it cannot specify the defined partition but in Analysis Services, it shows that my partitions are created...

Any idea why I get this error?

Thanks!

[Micha_]

Hello naelske_cronos,

we have the same problem, but looking for a solution with "applyRefreshPolicy : true" because we would like to automatically create new partitions when a new month or quarter starts. Unfortunately "applyRefreshPolicy : true" only works in commitMode transactionaly and therefore it would roll back the whole refresh in case of errors. Due to that we would like to refresh single partitions in transactional mode.
Has anybody an idea how we can automatically apply refresh policy?

Best

Micha

[Don-Bot]

Were you able to figure this out?  I'm looking at setting up an update partition via code and I'm not sure how to apply the refresh policy to find new partitions for the new day.  

[naelske_cronos]

Hello,

I also want to state that this json content in my body in Postman works but it refreshes the wrong partition. It actually refreshes the partition that is part of the incremental refresh instead of the one that is part of the archived refresh.

When I wrap my object in an array like in the documentation (https://learn.microsoft.com/en-us/power-bi/connect-data/asynchronous-refresh#post-refreshes), it gives me the error from in my first message:

Thanks!

[naelske_cronos]

Hello,

I've managed to solve my own problem. I had to add "applyRefreshPolicy : false"