topic Re: How to call API dynamically in Report Server

How to call API dynamically

Anonymous — Fri, 24 Sep 2021 06:58:36 GMT

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

pls give solution if any. Thanks in advance

whereismydata — Fri, 24 Sep 2021 08:46:48 GMT

Hi Anonymous

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

best

v-henryk-mstf — Mon, 27 Sep 2021 06:55:35 GMT

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.

Anonymous — Mon, 27 Sep 2021 07:38:04 GMT

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 — Mon, 27 Sep 2021 08:47:15 GMT

Hi Anonymous ,

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

Best Regards,
Henry

whereismydata — Tue, 28 Sep 2021 06:47:25 GMT

Hi,