Forum Discussion
How to connect Amazon MWS API to PowerBI? need help
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
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.
2 Replies
- v-easonf-msft
Community Support
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. 
adelheniHelper III
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/)