How do I pull Many-Date requests?

[Aregets]

I have 2 endpoints that most of my data comes from that uses "/{Start Date}/{End Date}"

For this I have made a parameter for the {Start Date} to begin where our data starts, and a parameter for {End Date} being "Today()" and just filter the data as needed.

I now added an Endpoint that uses "/{Business Date}" that only pulls single dates.

While trying to figure this out, I have also realized that some of my "/{Start Date}/{End Date}" endpoints request returns no DATE to help reference.

Question 1: Is there a way to pull a request for each "/{Business Day}"? (like a loop?)

Question 2: How would I handle receiving the "/{Start Date}/{End Date}" endpoint that has no DATE reference? Could I also pull each day with solution from Question 1 and conditionally add a DATE column myself?

[ronrsnfld · Accepted solution]

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].

[V-yubandi-msft]

Hi @Aregets ,

We wanted to follow up as we haven't received a response yet. We hope our solution was helpful. If you need further assistance or have any additional questions, please feel free to reach out.

We are always here to support you and appreciate your feedback. We look forward to hearing from you soon.

Thank you.

[Omid_Motamedise]

see this video for applying loop in power query
https://youtu.be/G8PRbWuDcmQ?si=3EIHpUpT4u96jDID

[V-yubandi-msft · Accepted solution]

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.

[V-yubandi-msft]

Hi @Aregets ,

We noticed we haven't received a response from you yet, so we wanted to follow up and ensure the solution we provided addressed your issue. If you require any further assistance or have additional questions, please let us know.

Your feedback is valuable to us, and we look forward to hearing from you soon.

Thank You.

[V-yubandi-msft]

Hi @Aregets ,

We are following up as we have not yet received a response from you. We hope the solution provided was helpful. Should you require further assistance or have additional questions, please feel free to reach out. Your feedback is highly valued, and we look forward to your response.

Thank You.

[ronrsnfld · Accepted solution]

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].