topic Re: How to automate API Data? in Developer

How to automate API Data?

Alexandra_B — Tue, 21 Jun 2022 11:37:30 GMT

Hello.

My job is to create reports and dashboards for the company I work for and for some of our clients. We have data from API, but cannot be linked to Power BI through "Get data" - "Web" option. So what I have done so far was to call the API using Postman, save and update the results in JSON files by calling a JavaScript file in VS Code, then I use those JSON files as data to be added into Power BI.

I can only execute the code while at work in the office, I cannot do it if I`m away for example.
What is the best way to automate this process?

Thank you.

Re: How to automate API Data?

Hariharan_R — Wed, 22 Jun 2022 09:22:33 GMT

Hi @Alexandra_B

Can you explain why you can't use Get Data option? is it because of authentication?

Ref - https://addendanalytics.com/blog/bring-data-in-power-bi-via-apis-using-basic-authentication/

You still can generate a token if needed for your API and then use it in Power Query.

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin

Re: How to automate API Data?

Alexandra_B — Wed, 22 Jun 2022 10:27:20 GMT

Hello, @Hariharan_R . I can access the API fine via other methods (e.g. Postman), but unable to do the same via Power BI. I think it’s because the API requires both Basic Authentication and additional authentication parameters, which it appears is not supported currently in Power BI Desktop.