Forum Discussion

Rigolleto's avatar
Rigolleto
Resolver I
4 years ago
Solved

Use Walmart API to get data transactions

Hi,   Since Walmart has a API available to get its data, I am wondering if I can call the API from PBI?   Is there a way to resolve an API and populate some matrixs?   Thanks  
Tips and Tricks
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi Rigolleto 

     

    Yes, it is possible to get data from an API with Power BI. For a simple GET request to an API, you can use the Web connector directly. Go to Get data > Web. Select Advanced option if it requires some more header parameters in the request.

     

    If a request is more complicated or it's a POST request, you need to write some M codes which includes Web.Contents and paste the codes in Advanced Editor of a query in Power Query Editor to call an API. 

     

    You could refer to this article Getting Started with API's in Power Query • My Online Training Hub to start exploring it. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi Rigolleto 

 

Yes, it is possible to get data from an API with Power BI. For a simple GET request to an API, you can use the Web connector directly. Go to Get data > Web. Select Advanced option if it requires some more header parameters in the request.

 

If a request is more complicated or it's a POST request, you need to write some M codes which includes Web.Contents and paste the codes in Advanced Editor of a query in Power Query Editor to call an API. 

 

You could refer to this article Getting Started with API's in Power Query • My Online Training Hub to start exploring it. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.