Forum Discussion
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
1 Reply
- v-yadongf-msftCommunity Support
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.