Multiple API calls with different dates

[Syndicate_Admin]

Good afternoon, I hope one of you can help me, I tell you the case:

I am making a call to the following API in the format I specify

So far so good, since the answer is good

The only problem is that the data is total between the dates I indicate in the API call.

I have been looking at different forums like this to try to solve https://community.powerbi.com/t5/Desktop/How-to-create-parameter-for-dynamic-date-parameter-in-json-... but the query with the parameter gives me error:

Example:

I want data from these 4 dates, therefore I must make 4 calls to the API, for this I have created a table of dates

and added a custom column as in the url indicated in the previous paragraph but it gives me an error:

Neither pointing to Column1 nor to the Custom column

I hope you can help me

Thanks a lot

Best regards

[v-yadongf-msft]

Hi @Syndicate_Admin ,

Please refer to: Dynamic API parameters in Power BI

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.