How to connect Amazon MWS API to PowerBI? need help

[aerox11]

HI

i want to connect amazon MWS API to PowerBI

Did anybody did it so far? Is there a way to do it?

I need help

https://blog.openbridge.com/amazon-releases-modern-selling-partner-api-sp-api-2a5641341c28

[adelheni]

Hi, 
There is multiple ways to do this.

- Manually, by Downloading Data from Amazon MWS and then uploading to power bi 

- Generating an API and Key and then in Power bi Get data -> from web and adding the link there.

- Automatically, you could use a third-party connector which is pretty easy to setup, this one will get you the results you need if you want to connect amazon mws to  power bi  ( https://windsor.ai/connect-amazon-mws-to-power-bi/)

[v-easonf-msft · Accepted solution]

Hi, @aerox11 

Same topic  has been raised by other user here.

https://community.powerbi.com/t5/Power-Query/Connect-to-MWS-Amazon-Seller-Central-API/td-p/201417

As of now,Powerbi doesn't support to  directly connect to MWS.You need  a thirdparty tool to get data from MWS  first. ZappySys has Amazon MWS connector which allows you to query using SQL language and import MWS data to Power BI / other apps (excel, SSRS, SQL Server). MWS works with Postman as well. 

In addition , you can  vote for this new idea and add your comments there to make this feature coming sooner

https://ideas.powerbi.com/ideas/idea/?ideaid=8bf260d2-851c-4df6-8cc2-b6be05d78fd9 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.