Data from Web Based APIs into Power Bi

[grey_griffin]

Hi Guys,

I'm completely new to Power Bi.

I'm wanting to find out how I can retrive data from Web APIs. I have the API URL queries for the respective Web APIs and can confirm they work.

With the retrived data, I'd like to build a report and also have the data retrieval automated.

Any help would be greatly appreciated.

[siddiq8686khi]

I tried all the above but still, the tables are getting blank.

[Anonymous]

HI @grey_griffin,

I'd like to suggest you take a look at the following link about using web connector to get data from the rest API with authorization:

Solved: Pull data from a REST API Authentication - Microsoft Power BI Community

Regards,

Xiaoxin Sheng

[Fowmy · Accepted solution]

@grey_griffin 

I would like to recommend this video for you: https://www.youtube.com/watch?v=a0FqNLI0VsQ