Load datas using incremaental

[Anonymous]

I'm trying to find a way to do the process describe below :

-first request return a total number of record to be loaded (json.documents)

Keep the number of record to be loaded & loaded data using 100 record by 100 record

-load data mutiple time to load all data regarding original number of record. (json.document too)

How to do this in PowerBi.

Sample :

load 1 : return a field who give us 153 records.

load 2 : load the 100 first record

load 3 : load the next 53 records

load 4 : combine data from load 2 & 3, and do same tranformation.

Many thanks for your help,

Gaetan

[v-piga-msft]

Hi @Anonymous ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best  Regards,

Cherry

[Anonymous]

Hi,

Unfortunatly the solution proposed doesnt match with my need.

If we assume that my load could be splitted as partial load, the origine of the new load is not based on date, but a number.

Any idea to store this data & load multiple time till all data are loaded  (see my original request).

Best regards,

[v-piga-msft]

Hi @Anonymous ,

I'm afraid that you mentioned is similar to Incremental refresh in Power BI.

Please refer to Incremental refresh feature in power bi.

Reference:https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh

Best Regards,

Cherry