Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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...
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...
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 @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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
9 | |
8 | |
4 | |
2 | |
2 |
User | Count |
---|---|
12 | |
7 | |
7 | |
2 | |
2 |