Forum Discussion
Loop between two dates step 1 year
I have such step = Table.AddColumn(#"Removed Other Columns", "Custom", each fxReports([id],RangeStart,RangeEnd)) Problem is what RangeStart,RangeEnd limited by API by 1 year, So i need loop thi...
HI Digger,
Perhaps you can create a parameter table to split your range to multiple rows and different start/end date ranges, then you can add a column invoke your function with these new ranges. After these steps, you can simply merge the result column to a new table to get the whole ranges records.
In addition, you can also take a look at the following helper function paginated API usage if helps:
Helper functions for M extensions for Power Query connectors - Power Query | Microsoft Learn
Regards,
Xiaoxin Sheng