Forum Discussion
How to generate Access Token
Please do not publish your credentials on the interwebs.
As you can probably appreciate it is nearly impossible to help with API queries without access to said API (which you should not provide for understandable reasons)Consult the documentation of your API. In your case the API requires an API Key. There is an example for that in https://learn.microsoft.com/en-us/powerquery-m/web-contents
Use tools like Postman to figure out the mechanics of your call and then implement that in Power Query.
Hi lbendlin
Have used Postman and get the access token successfully. But when it comes to power query, it always ask to provide credentials. Don't know what the problem is.
You may need to provide an API Key. Please follow the example in the documentation.