Forum Discussion
How to connect Amazon MWS API to PowerBI? need help
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.
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/)