topic Re: Organizational Walmart API to PowerBI in Developer

Organizational Walmart API to PowerBI

zupky — Sun, 05 Jan 2025 23:04:03 GMT

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?

Re: Organizational Walmart API to PowerBI

lbendlin — Sun, 05 Jan 2025 23:43:59 GMT

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.

Re: Organizational Walmart API to PowerBI

zupky — Sun, 05 Jan 2025 23:47:05 GMT

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.

Re: Organizational Walmart API to PowerBI

lbendlin — Sun, 05 Jan 2025 23:50:39 GMT

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)

Re: Organizational Walmart API to PowerBI

zupky — Mon, 06 Jan 2025 01:42:21 GMT

i have done it like what I did in postman

Re: Organizational Walmart API to PowerBI

lbendlin — Mon, 06 Jan 2025 12:28:24 GMT

Clear permissions in Data Source Settings and try again with anonymous auth.

Re: Organizational Walmart API to PowerBI

Anonymous — Tue, 07 Jan 2025 06:34:48 GMT

Thanks for the reply from lbendlin , please allow me to provide another insight:

Hi, @zupky
Thanks for reaching out to the Microsoft fabric community forum.

Could you please confirm if lbendlin's response has resolved your issue? If it has, kindly accept his response as the solution. This will greatly benefit other community members who have similar issues by helping them find solutions more quickly. Of course, if you have discovered a solution yourself, we would also appreciate it if you could share your response with us.

Regarding lbendlin's suggestion, to facilitate your search, you may try the following methods:

1.In the desktop settings section:

2.In the Power Query data source section:

3.For further details, please refer to:

Authentication in desktop apps - Power Query | Microsoft Learn

4.Below is a solution for a similar issue by clearing the data source credentials:

Solved: We couldn't authenticate with the credentials prov... - Microsoft Fabric Community

Additionally, regarding your issue, you may find the following video resources helpful:

https://www.youtube.com/watch?v=a0FqNLI0VsQ
Solved: Can not connect with REST API. We couldn't authent... - Microsoft Fabric Community

Lastly, here are responses and official documentation related to your issue:

Solved: Pull data from RESTful API with token authenticati... - Page 2 - Microsoft Fabric Community
Web.Contents - PowerQuery M | Microsoft Learn

Of course, if you have any new discoveries or questions, please feel free to get in touch with us.

Best Regards,

Leroy Lu

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