How to call API dynamically

[Keerthi_505]

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

[whereismydata · Accepted 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... 

[v-henryk-mstf]

Hi @Keerthi_505 ,

I think referring to the steps in the video below can guide you how to dynamically obtain values through the API.

Call Power BI Rest API with Dynamic Access Token From Power BI Desktop |Power BI Rest API | Part Two...

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.

[Keerthi_505]

Hi @v-henryk-mstf 

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

[v-henryk-mstf]

Hi @Keerthi_505 ,

I can’t view the content in the picture. Can you upload the high-definition big picture again?

Best Regards,
Henry

[whereismydata]

Hi @Keerthi_505 

maybe this will help you: https://community.powerbi.com/t5/Desktop/Dynamic-Nested-API-Calls/td-p/250267

or this: https://community.powerbi.com/t5/Community-Blog/Turning-quot-Web-by-Example-quot-into-Power-Query-Fu...

Although it might be possible, I use a python script for my api handling

best