Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Connecting Web API using Postman (collection and Environment)

Hello All,

 

I have a post man collection that is rather large. It calls on a postman enviornment for all information I believe should be kept secure (such as API key, bearer token, ect). I tried to follow the microsoft instructions to create a custom connector but it doesn't work as I would hope. I think I will need to go through and add the values that were being called from the enviornment into each "Get" or "Post" function. I am new to API and would appreciate any help o nhow to use my API calls. Is there an easy way to make a call using my "GET" function for all employees and then having that table in PowerBI ready to use?

 

When I try to connect directly to any of my web API calls using the WEB option on PowerBI I always recieve the error "Authentication" must be used anonymously. 

 

Any help on how to use a WEB API would be amazing.

 

Thank you.

2 Replies

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Community Support

    Hi Anonymous ,

     

    You need to get access token befor you call the REST API. That is "Authentication".

     

     

    How to get access token please refer this post.

    Solved: REST API Get Access Token - Microsoft Power BI Community

     

     

    Best Regards

    Community Support Team _ chenwu zhu

     

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you! I have been using this token in a header labeled "Authentication" but it is popping up with the following error:

       

      Here is an example of what I put in:

       

      For reference these are example API calls from the company website I am attemptying to call information form:

      REST API Reference Guide (saashr.com)

       

      Thank you very much for your help