How do I pull Many-Date requests?

Question 1: You can use List.Accumulate.

Question 2: I don't understand what you mean. If there is no data between [Start Date] and [End Date] there's nothing to pull. If  there is, ensure your filter checks for dates between as well as the actual dates ege: data >=[Start Date] and data <=[End Date].

Hi Aregets ,

Thank you for reaching out to Microsoft Fabric.

1. Using a list accumulation approach in Power Query within Power BI. This technique essentially functions like a loop, generating a list of business days and then making API calls for each date.

Link:  List.Accumulate - PowerQuery M | Microsoft Learn.

2.  The issue of receiving the /{Start Date}/{End Date} endpoint with no date reference can be resolved by setting up incremental refresh in Power BI. This approach ensures efficient data updates.

An official Microsoft document has been attached, providing detailed information on this topic. Please review it when possible for further insights.

Link: Configure incremental refresh for Power BI semantic models - Power BI | Microsoft Learn.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.