topic Re: Enhanced Refresh API Incremental Refresh - Cannot specify partition in Developer

Enhanced Refresh API Incremental Refresh - Cannot specify partition

naelske_cronos — Tue, 18 Apr 2023 18:02:37 GMT

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/?trackingId=xfQO%2Fw%2BfQXm9Zvmipp4ljA%3D%3D

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!

Re: Enhanced Refresh API Incremental Refresh - Cannot specify partition

naelske_cronos — Wed, 19 Apr 2023 08:34:25 GMT

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!

Re: Enhanced Refresh API Incremental Refresh - Cannot specify partition

naelske_cronos — Wed, 19 Apr 2023 11:26:23 GMT

Hello,

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

Re: Enhanced Refresh API Incremental Refresh - Cannot specify partition

Micha_ — Wed, 19 Apr 2023 14:24:19 GMT

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

Re: Enhanced Refresh API Incremental Refresh - Cannot specify partition

Don-Bot — Wed, 27 Mar 2024 21:47:14 GMT

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.