Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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,
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.