Rest API as data Source - Use Case

[sthatoju]

Hello Experts,

Could anyone please guide me on how to pull the data from the Rest API.

I have a list of APIs, which will connect through a login token(bearer token) and I want to pull the data to Power BI Desktop to build 

Thanks

Santhosh

[Fowmy · Accepted solution]

@sthatoju 

You can connect using Power Query, the genral format will be:

let
    BearerToken = "YOUR_BEARER_TOKEN",
    ApiUrl = "https://api.example.com/data",
    Source = Web.Contents(ApiUrl,
        [
            Headers = [Authorization = "Bearer " & BearerToken]
        ]
    ),
    JsonResponse = Json.Document(Source)
in
    JsonResponse

[Anonymous · Accepted solution]

Hi @sthatoju , hello Fowmy, thank you for your prompt reply!

I agree with Fowmy, and as a supplement,let's see how we can leverage the API in Power Query via web.contents:

Web.Contents is a powerful function in Power Query that enables you to retrieve web content directly, without the need for a browser.

This function is especially beneficial for accessing APIs that return data in formats such as JSON or CSV.

By utilizing the Authorization header along with your bearer token, you can securely access protected resources, ensuring that your data retrieval is both efficient and secure.

I hope the following article is helpful:
Web.Contents and APIs in Power BI

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Fowmy · Accepted solution]

@sthatoju 

You can connect using Power Query, the genral format will be:

let
    BearerToken = "YOUR_BEARER_TOKEN",
    ApiUrl = "https://api.example.com/data",
    Source = Web.Contents(ApiUrl,
        [
            Headers = [Authorization = "Bearer " & BearerToken]
        ]
    ),
    JsonResponse = Json.Document(Source)
in
    JsonResponse

[sthatoju]

Thanks @Fowmy  for your reply.

I will try it out. However, could you please confirm me that, this power query setup will work for the endusers(consumers), who will run the report.

I want to build a report and deliver to the end users.

Thanks

Santhosh

[Fowmy]

@sthatoju 

It should as you use a token to authenticate