Forum Discussion
Organizational Walmart API to PowerBI
Good day, everyone!
Postman already gave me an access token and displayed the data I requested. However, I don't know how to integrate it to power BI automatically. All the basic web options are not working for it shows like "We couldnt authenticate with the credentials provided. Please try again." or "A web API key can only be specified when a Web API key name is provided".
Advanced, on the other hand, also leads me to the basic web option even if I created an authorization header with bearer accesstoken. What should I do with this?
6 Replies
How did it work in Postman? Did you provide the token as part of the authentication header?
You may have provided wrong credential type and that is now cached. Clear all permissions, and then ty again with anonymous auth and your token in the header . Don't forget the "Bearer " part.
Yup, both my authorization and WM_SEC.ACCESS_TOKEN. In my GET token request it shows that i have full access, and i tried to specify the GET item it also displays responses.
show a sanitized version of the Power Query code.
As you can probably appreciate it is nearly impossible to help with API queries without access to said API (which you may not be willing to provide for understandable reasons)
