Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Load datas using incremaental

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

 

 

 

Show and Tell
Tutorial Requests

3 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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,