Forum Discussion
How to call API dynamically
Hello,
I would like to know if it is possible to dynamically pull data from a web API?
Because of the API structure I am not able to pull in the data I need in one call.
The API URL is structure like
https://url/Home/name?Key=xyz&requestid=
pls give solution if any. Thanks in advance
Hi,
since the post is not marked as solved yet, maybe this link will help you:
https://www.burningsuit.co.uk/blog/2021/09/i-have-the-powerquery-using-power-query-to-call-rest-apis/
5 Replies
Hi Anonymous
maybe this will help you: https://community.powerbi.com/t5/Desktop/Dynamic-Nested-API-Calls/td-p/250267
Although it might be possible, I use a python script for my api handling
best
Hi Anonymous ,
I think referring to the steps in the video below can guide you how to dynamically obtain values through the API.
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Previously I was able to call API into Power bi through web.
I cleared the permissions in datasource settings after that I am not able to call a Single row.
I am getting the following error.
I haven't given any credentials here but still it is showing couldn't authenticate credentials.
Pl help me how to resolve the issue.
Regards,
Keerthi
Hi Anonymous ,
I can’t view the content in the picture. Can you upload the high-definition big picture again?
Best Regards,
Henry
Hi,
since the post is not marked as solved yet, maybe this link will help you:
https://www.burningsuit.co.uk/blog/2021/09/i-have-the-powerquery-using-power-query-to-call-rest-apis/
