Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Multiple API calls with different dates

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-api/td-p/1004247 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