Connecting Web API using Postman (collection and Environment)

[Anonymous]

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.

[v-chenwuz-msft]

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]

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